﻿SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_member_balance_record
-- ----------------------------
DROP TABLE IF EXISTS `t_member_balance_record`;
CREATE TABLE `t_member_balance_record`
(
    `id`                bigint                                                         NOT NULL AUTO_INCREMENT,
    `create_time`       datetime                                                       NULL DEFAULT NULL COMMENT '创建时间',
    `tenant_id`         varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci   NULL DEFAULT NULL COMMENT '租户id',
    `use_balance`       decimal(10, 2)                                                 NULL DEFAULT NULL COMMENT '使用余额',
    `remaining_balance` decimal(10, 2)                                                 NULL DEFAULT NULL COMMENT '剩余余额',
    `member_info_id`    bigint                                                         NULL DEFAULT NULL COMMENT '会员id或shopUserId',
    `change_type`       tinyint(1)                                                     NULL DEFAULT NULL COMMENT '变化类型 0-添加 1-减少',
    `detail_name`       varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '明细名',
    `order_id`          bigint                                                         NULL DEFAULT NULL COMMENT '订单id',
    `deal_type`         tinyint(1)                                                     NULL DEFAULT NULL COMMENT '交易类型 0-用户消费(购买商品) 1-微信充值 2-商家充值 3-退款成功',
    `is_deleted`        tinyint(1)                                                     NULL DEFAULT NULL COMMENT '删除状态：0->未删除；1->已删除',
    `update_time`       datetime                                                       NULL DEFAULT NULL COMMENT '更新时间',
    `source`            tinyint(1)                                                     NULL DEFAULT NULL COMMENT '订单来源：1-会员，2-商品，3-积分',
    `out_order_id`      bigint                                                         NULL DEFAULT NULL COMMENT '外部订单id',
    PRIMARY KEY (`id`)
)
    ENGINE = InnoDB
    DEFAULT CHARACTER SET = utf8mb4
    COLLATE = utf8mb4_0900_ai_ci
    COMMENT ='账户余额明细表'
    AUTO_INCREMENT = 252
;

-- ----------------------------
-- Records of t_member_balance_record
-- ----------------------------
BEGIN;
INSERT INTO `t_member_balance_record`
VALUES ('207', '2020-08-01 09:46:24', '100002', '0.01', '0.42', '1248795148536647680', '0', '消费返利',
        '1000022008012241224', '2', '0', '2020-08-01 09:46:24', '2', '1289376344745533442'),
       ('208', '2020-08-01 10:37:59', '100002', '0.01', '3.54', '1246647917666766848', '0', '消费返利',
        '1000022008013002460', '2', '0', '2020-08-01 10:37:59', '2', '1289389012428611586'),
       ('209', '2020-08-01 10:43:26', '100002', '1000.01', '10483.47', '199', '0', '微信充值（参与充值活动充0.01送1000)',
        '1000022008014432103', '1', '0', '2020-08-01 10:43:26', '1', '1000022008011311013'),
       ('210', '2020-08-01 11:37:32', '100002', '39.00', '10448.01', '199', '1', '会员续费', '1000022008013462015', '0',
        '0', '2020-08-01 11:37:32', '1', '1000022008011541403'),
       ('211', '2020-08-01 12:12:06', '100002', '58.40', '18694.42', '199', '1', '会员升级', '1000022008016512322', '0',
        '0', '2020-08-01 12:12:06', '1', '1000022008013514044'),
       ('212', '2020-08-01 12:12:58', '100002', '80.30', '18672.52', '199', '1', '会员升级', '1000022008011253414', '0',
        '0', '2020-08-01 12:12:58', '1', '1000022008013132453'),
       ('213', '2020-08-01 13:36:05', '100002', '1000.01', '1000.01', '201', '0', '微信充值（参与充值活动充0.01送1000)',
        '1000022008015156415', '1', '0', '2020-08-01 13:36:05', '1', '1000022008011232031'),
       ('214', '2020-08-01 13:39:00', '100002', '60.00', '940.01', '201', '1', '购买1件商品', '1000022008012544253', '0',
        '0', '2020-08-01 13:39:00', '2', '1289435432036687873'),
       ('215', '2020-08-01 13:43:40', '100002', '2.01', '233.26', '1247329015887433728', '1', '购买1件商品',
        '1000022008016611132', '0', '0', '2020-08-01 13:43:40', '2', '1289436604768280577'),
       ('216', '2020-08-01 14:22:21', '100002', '1.50', '95.89', '1247329015887433728', '0', '消费返利',
        '1000022008013365001', '2', '0', '2020-08-01 14:22:21', '2', '1289436604768280577'),
       ('217', '2020-08-01 14:34:08', '100002', '0.01', '118772.25', '202', '1', '开通会员', '1000022008011425255', '0',
        '0', '2020-08-01 14:34:08', '1', '1000022008011266225'),
       ('218', '2020-08-01 14:35:56', '100002', '40.04', '118718.76', '202', '1', '会员升级', '1000022008015546320', '0',
        '0', '2020-08-01 14:35:56', '1', '1000022008014651515'),
       ('219', '2020-08-01 14:44:08', '100002', '21.89', '212.87', '1247329015887433728', '1', '购买1件商品',
        '1000022008013324260', '0', '0', '2020-08-01 14:44:08', '2', '1289451825419341826'),
       ('220', '2020-08-01 14:50:26', '100002', '58.24', '118700.56', '202', '1', '会员升级', '1000022008013334421', '0',
        '0', '2020-08-01 14:50:26', '1', '1000022008012056021'),
       ('221', '2020-08-01 20:27:34', '100002', '11.00', '929.01', '201', '1', '购买1件商品', '1000022008010320626', '0',
        '0', '2020-08-01 20:27:34', '2', '1289538250588377090'),
       ('222', '2020-08-01 20:52:30', '100002', '5.00', '10304.31', '199', '1', '购买1件商品', '1000022008010426322', '0',
        '0', '2020-08-01 20:52:30', '2', '1289544525602705410'),
       ('223', '2020-08-01 20:57:13', '100002', '24.60', '10279.71', '199', '1', '购买3件商品', '1000022008012343644', '0',
        '0', '2020-08-01 20:57:13', '2', '1289545713396043777'),
       ('224', '2020-08-01 21:25:42', '100002', '0.01', '10279.70', '199', '1', '购买4件商品', '1000022008010405042', '0',
        '0', '2020-08-01 21:25:42', '2', '1289552880035516417'),
       ('225', '2020-08-04 20:31:21', '100002', '5.55', '5.55', '1246366999534243840', '0', '消费返利',
        '1000022008044006144', '2', '0', '2020-08-04 20:31:21', '2', '1290624721055469569'),
       ('226', '2020-08-04 20:46:15', '100002', '22.20', '27.75', '1246366999534243840', '0', '消费返利',
        '1000022008045154340', '2', '0', '2020-08-04 20:46:15', '2', '1287750766611226625'),
       ('227', '2020-08-04 20:47:57', '100002', '10.00', '10269.70', '199', '1', '购买1件商品', '1000022008043344561', '0',
        '0', '2020-08-04 20:47:57', '2', '1290630543487619073'),
       ('228', '2020-08-04 22:02:35', '100002', '5.55', '33.30', '1246366999534243840', '0', '消费返利',
        '1000022008044661430', '2', '0', '2020-08-04 22:02:35', '2', '1290636414942793730'),
       ('229', '2020-08-05 00:47:56', '100002', '22.20', '55.50', '208', '0', '消费返利', '1000022008056310616', '2', '0',
        '2020-08-05 00:47:56', '2', '1286885408257953794'),
       ('230', '2020-08-06 21:13:26', '100002', '5.55', '61.05', '208', '0', '消费返利', '1000022008062124314', '2', '0',
        '2020-08-06 21:13:26', '2', '1291361401072865281'),
       ('231', '2020-08-07 13:53:15', '100002', '0.01', '145.42', '1260737223138086912', '1', '购买积分商品',
        '1000022008073320535', '0', '0', '2020-08-07 13:53:15', '3', '24303346504641'),
       ('232', '2020-08-07 13:54:36', '100002', '0.02', '145.40', '1260737223138086912', '1', '购买1件商品',
        '1000022008071113361', '0', '0', '2020-08-07 13:54:36', '2', '1291613684893306881'),
       ('233', '2020-08-07 13:55:06', '100002', '0.02', '145.38', '1260737223138086912', '1', '购买1件商品',
        '1000022008073655145', '0', '0', '2020-08-07 13:55:06', '2', '1291613812802801665'),
       ('234', '2020-08-07 13:57:07', '100002', '20.01', '125.37', '1260737223138086912', '1', '购买1件商品',
        '1000022008071003603', '0', '0', '2020-08-07 13:57:07', '2', '1291614318778470402'),
       ('235', '2020-08-07 14:21:05', '100002', '1.00', '1.00', '1260737223138086912', '0', '消费返利',
        '1000022008074211633', '2', '0', '2020-08-07 14:21:05', '2', '1291614318778470402'),
       ('236', '2020-08-11 22:04:31', '100002', '0.02', '118673.95', '210', '1', '开通会员', '1000022008116604336', '0',
        '0', '2020-08-11 22:04:31', '1', '1000022008111625215'),
       ('237', '2020-08-11 22:23:13', '100002', '1.00', '118672.95', '211', '1', '开通会员', '1000022008112251643', '0',
        '0', '2020-08-11 22:23:13', '1', '1000022008113354641'),
       ('238', '2020-08-12 21:17:21', '100002', '30.00', '118642.95', '202', '1', '会员续费', '1000022008125654210', '0',
        '0', '2020-08-12 21:17:21', '1', '1000022008124162333'),
       ('239', '2020-08-12 21:22:18', '100002', '30.00', '118612.95', '202', '1', '会员续费', '1000022008126501523', '0',
        '0', '2020-08-12 21:22:18', '1', '1000022008122533065'),
       ('240', '2020-08-17 08:41:04', '100002', '1000.01', '1001.51', '214', '0', '微信充值（参与充值活动充0.01送1000)',
        '1000022008170026660', '1', '0', '2020-08-17 08:41:04', '1', '1000022008175214204'),
       ('241', '2020-08-17 14:53:06', '100002', '1000.01', '1212.88', '203', '0', '微信充值（参与充值活动充0.01送1000)',
        '1000022008175062662', '1', '0', '2020-08-17 14:53:06', '1', '1000022008172626212'),
       ('242', '2020-08-17 14:54:01', '100002', '11.00', '1297.77', '203', '1', '购买1件商品', '1000022008174142405', '0',
        '0', '2020-08-17 14:54:01', '2', '1295252518487023618'),
       ('243', '2020-08-17 14:54:19', '100002', '0.03', '1297.74', '203', '1', '购买3件商品', '1000022008171636500', '0',
        '0', '2020-08-17 14:54:19', '2', '1295252592566820866'),
       ('244', '2020-08-17 14:54:35', '100002', '20.00', '1277.74', '203', '1', '购买1件商品', '1000022008175602124', '0',
        '0', '2020-08-17 14:54:35', '2', '1295252659650519041'),
       ('245', '2020-08-18 08:38:26', '100002', '11.00', '1266.74', '203', '1', '购买1件商品', '1000022008181241646', '0',
        '0', '2020-08-18 08:38:26', '2', '1295520386193641473'),
       ('246', '2020-08-18 08:39:33', '100002', '2.01', '1264.73', '203', '1', '购买1件商品', '1000022008184556031', '0',
        '0', '2020-08-18 08:39:33', '2', '1295520666792579073'),
       ('247', '2020-08-18 08:40:15', '100002', '100.01', '1164.72', '203', '1', '购买1件商品', '1000022008184304205', '0',
        '0', '2020-08-18 08:40:15', '2', '1295520844572348417'),
       ('248', '2020-09-01 22:03:48', '100002', '2.01', '927.00', '201', '1', '购买1件商品', '1000022009010031024', '0', '0',
        '2020-09-01 22:03:48', '2', '1300796490848489474'),
       ('249', '2020-09-02 20:44:10', '100002', '100.01', '826.99', '201', '1', '购买1件商品', '1000022009025352000', '0',
        '0', '2020-09-02 20:44:10', '2', '1301138838364827650'),
       ('250', '2020-09-04 22:16:22', '100002', '0.01', '826.98', '201', '1', '购买1件商品', '1000022009046450543', '0', '0',
        '2020-09-04 22:16:22', '2', '1301886819481366530'),
       ('251', '2020-09-04 22:18:11', '100002', '0.01', '826.97', '201', '1', '购买1件商品', '1000022009043604123', '0', '0',
        '2020-09-04 22:18:11', '2', '1301887274076811266');
COMMIT;

-- ----------------------------
-- Table structure for t_member_card_goods
-- ----------------------------
DROP TABLE IF EXISTS `t_member_card_goods`;
CREATE TABLE `t_member_card_goods`
(
    `id`             bigint                                                        NOT NULL AUTO_INCREMENT,
    `create_time`    datetime                                                      NULL DEFAULT NULL COMMENT '创建时间',
    `tenant_id`      varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL DEFAULT NULL COMMENT '租户id',
    `member_card_id` bigint                                                        NULL DEFAULT NULL COMMENT '会员卡id',
    `goods_id`       varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '商品id',
    `is_deleted`     tinyint(1)                                                    NULL DEFAULT NULL,
    `update_time`    datetime                                                      NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
)
    ENGINE = InnoDB
    DEFAULT CHARACTER SET = utf8mb4
    COLLATE = utf8mb4_0900_ai_ci
    COMMENT ='会卡购买指定商品关联表'
    AUTO_INCREMENT = 275
;

-- ----------------------------
-- Records of t_member_card_goods
-- ----------------------------
BEGIN;
INSERT INTO `t_member_card_goods`
VALUES ('265', '2020-08-01 09:41:48', '100002', '1374', '1178', '0', '2020-08-01 09:41:48'),
       ('266', '2020-08-01 09:41:48', '100002', '1375', '1173', '0', '2020-08-01 09:41:48'),
       ('267', '2020-08-01 09:41:48', '100002', '1376', '1137,1140', '0', '2020-08-01 09:41:48'),
       ('268', '2020-08-01 09:41:48', '100002', '1377', '1111', '0', '2020-08-01 09:41:48'),
       ('269', '2020-08-01 09:41:48', '100002', '1378', '254,962', '0', '2020-08-01 09:41:48'),
       ('270', '2020-08-01 09:56:53', '100002', '1389', '1279', '0', '2020-08-01 09:56:53'),
       ('271', '2020-08-01 09:56:53', '100002', '1390', '1278', '0', '2020-08-01 09:56:53'),
       ('272', '2020-08-01 09:56:53', '100002', '1391', '1258', '0', '2020-08-01 09:56:53'),
       ('273', '2020-08-01 09:56:53', '100002', '1392', '1177', '0', '2020-08-01 09:56:53'),
       ('274', '2020-08-01 09:56:53', '100002', '1393', '1179', '0', '2020-08-01 09:56:53');
COMMIT;

-- ----------------------------
-- Table structure for t_member_card_info
-- ----------------------------
DROP TABLE IF EXISTS `t_member_card_info`;
CREATE TABLE `t_member_card_info`
(
    `id`                  bigint                                                        NOT NULL AUTO_INCREMENT,
    `create_time`         datetime                                                      NULL DEFAULT NULL COMMENT '创建时间',
    `tenant_id`           varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL DEFAULT NULL COMMENT '租户id',
    `rank_code`           varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci   NULL DEFAULT NULL,
    `rank_name`           varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL DEFAULT NULL COMMENT '会员卡名称',
    `back_ground_pic_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '会员卡图片',
    `title`               varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL DEFAULT NULL COMMENT '会员卡标题',
    `open_value`          decimal(10, 2)                                                NULL DEFAULT NULL COMMENT '开通所需值(付费金额或所需积分)',
    `introduce`           varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '会员卡介绍',
    `open_type`           tinyint(1)                                                    NULL DEFAULT NULL COMMENT '开卡方式 0-自动发卡 1-付费购买 2-积分兑换 3-累计消费 4-购买指定商品',
    `use_in_date`         bigint                                                        NULL DEFAULT NULL COMMENT '使用期限 按天计算  0表示不限制',
    `consume_condition`   decimal(10, 2)                                                NULL DEFAULT 0.00 COMMENT '开卡条件1 累计消费满多少元  0元表示不限制',
    `is_buy_goods`        tinyint(1)                                                    NULL DEFAULT 0 COMMENT '开卡条件2 是否需要购买指定商品,0-不需要 1-需要(查询关联子表',
    `is_deleted`          tinyint(1)                                                    NULL DEFAULT NULL COMMENT '删除状态：0->未删除；1->已删除',
    `update_time`         datetime                                                      NULL DEFAULT NULL COMMENT '更新时间',
    `is_open`             tinyint(1)                                                    NULL DEFAULT NULL COMMENT '特权开关 0-关闭 1-开启',
    `style`               tinyint(1)                                                    NULL DEFAULT NULL COMMENT '会员卡风格 1-系统风格 2-自定义风格',
    PRIMARY KEY (`id`)
)
    ENGINE = InnoDB
    DEFAULT CHARACTER SET = utf8mb4
    COLLATE = utf8mb4_0900_ai_ci
    COMMENT ='会员卡信息表'
    AUTO_INCREMENT = 1589
;

-- ----------------------------
-- Records of t_member_card_info
-- ----------------------------
BEGIN;
INSERT INTO `t_member_card_info`
VALUES ('1374', '2020-08-01 09:41:48', '100002', '1', '普通会员', null, '沃尔玛会员卡', null, null, '4', '365', '0.00', '1', '1',
        '2020-08-01 09:41:48', '1', null),
       ('1375', '2020-08-01 09:41:48', '100002', '2', '金卡会员', null, '沃尔玛会员卡', null, null, '4', '365', '0.00', '1', '1',
        '2020-08-01 09:41:48', '1', null),
       ('1376', '2020-08-01 09:41:48', '100002', '3', '钻石会员', null, '沃尔玛会员卡', null, null, '4', '365', '0.00', '1', '1',
        '2020-08-01 09:41:48', '1', null),
       ('1377', '2020-08-01 09:41:48', '100002', '4', '终极会员', null, '沃尔玛会员卡', null, null, '4', '365', '0.00', '1', '1',
        '2020-08-01 09:50:30', '0', null),
       ('1378', '2020-08-01 09:41:48', '100002', '5', '究极会员', null, '沃尔玛会员卡', null, null, '4', '365', '0.00', '1', '1',
        '2020-08-01 09:50:33', '0', null),
       ('1384', '2020-08-01 09:53:37', '100002', '1', '普通会员', null, '沃尔玛会员卡', '1.00', null, '2', '365', '0.00', '0',
        '1', '2020-08-01 09:53:37', '1', null),
       ('1385', '2020-08-01 09:53:37', '100002', '2', '金卡会员', null, '沃尔玛会员卡', '5.00', null, '2', '365', '0.00', '0',
        '1', '2020-08-01 09:53:37', '1', null),
       ('1386', '2020-08-01 09:53:37', '100002', '3', '钻石会员', null, '沃尔玛会员卡', '10.00', null, '2', '365', '0.00', '0',
        '1', '2020-08-01 09:53:37', '1', null),
       ('1387', '2020-08-01 09:53:37', '100002', '4', '', null, '沃尔玛会员卡', null, null, '2', '365', '0.00', '0', '1',
        '2020-08-01 09:53:37', '0', null),
       ('1388', '2020-08-01 09:53:37', '100002', '5', '', null, '沃尔玛会员卡', null, null, '2', '365', '0.00', '0', '1',
        '2020-08-01 09:53:37', '0', null),
       ('1389', '2020-08-01 09:56:53', '100002', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '沃尔玛会员卡', null, null, '4', '365', '0.00', '1', '1', '2020-08-01 09:56:53', '1', '1'),
       ('1390', '2020-08-01 09:56:53', '100002', '2', '金卡会员', 'https://oss-tencent.bgniao.cn/api/supremacy_card.png',
        '沃尔玛会员卡', null, null, '4', '365', '0.00', '1', '1', '2020-08-01 09:56:53', '1', '1'),
       ('1391', '2020-08-01 09:56:53', '100002', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '沃尔玛会员卡', null, null, '4', '365', '0.00', '1', '1', '2020-08-01 09:56:53', '1', '1'),
       ('1392', '2020-08-01 09:56:53', '100002', '4', '终极会员', null, '沃尔玛会员卡', null, null, '4', '365', '0.00', '1', '1',
        '2020-08-01 09:56:53', '1', null),
       ('1393', '2020-08-01 09:56:53', '100002', '5', '究极会员', null, '沃尔玛会员卡', null, null, '4', '365', '0.00', '1', '1',
        '2020-08-01 09:56:53', '1', null),
       ('1394', '2020-08-01 11:36:10', '100002', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '沃尔玛会员卡', '29.00', null, '1', '365', '0.00', '0', '1', '2020-08-01 11:36:10', '1', '1'),
       ('1395', '2020-08-01 11:36:10', '100002', '2', '金卡会员', 'https://oss-tencent.bgniao.cn/api/supremacy_card.png',
        '沃尔玛会员卡', '39.00', null, '1', '365', '0.00', '0', '1', '2020-08-01 11:36:10', '1', '1'),
       ('1396', '2020-08-01 11:36:10', '100002', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '沃尔玛会员卡', '59.00', null, '1', '365', '0.00', '0', '1', '2020-08-01 11:36:10', '1', '1'),
       ('1397', '2020-08-01 11:36:10', '100002', '4', '终极会员', null, '沃尔玛会员卡', '79.00', null, '1', '365', '0.00', '0',
        '1', '2020-08-01 11:36:10', '1', null),
       ('1398', '2020-08-01 11:36:10', '100002', '5', '究极会员', null, '沃尔玛会员卡', '129.00', null, '1', '365', '0.00', '0',
        '1', '2020-08-01 11:36:10', '1', null),
       ('1399', '2020-08-01 11:36:15', '100002', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '沃尔玛会员卡', '29.00', null, '1', '1', '0.00', '0', '1', '2020-08-01 11:36:15', '1', '1'),
       ('1400', '2020-08-01 11:36:15', '100002', '2', '金卡会员', 'https://oss-tencent.bgniao.cn/api/supremacy_card.png',
        '沃尔玛会员卡', '39.00', null, '1', '1', '0.00', '0', '1', '2020-08-01 11:36:15', '1', '1'),
       ('1401', '2020-08-01 11:36:16', '100002', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '沃尔玛会员卡', '59.00', null, '1', '1', '0.00', '0', '1', '2020-08-01 11:36:16', '1', '1'),
       ('1402', '2020-08-01 11:36:16', '100002', '4', '终极会员', null, '沃尔玛会员卡', '79.00', null, '1', '1', '0.00', '0', '1',
        '2020-08-01 11:36:16', '1', null),
       ('1403', '2020-08-01 11:36:16', '100002', '5', '究极会员', null, '沃尔玛会员卡', '129.00', null, '1', '1', '0.00', '0',
        '1', '2020-08-01 11:36:16', '1', null),
       ('1404', '2020-08-01 11:39:32', '100002', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '沃尔玛会员卡', '29.00', null, '1', '1', '0.00', '0', '1', '2020-08-01 11:39:32', '1', '1'),
       ('1405', '2020-08-01 11:39:32', '100002', '2', '金卡会员', 'https://oss-tencent.bgniao.cn/api/supremacy_card.png',
        '沃尔玛会员卡', '39.00', null, '1', '1', '0.00', '0', '1', '2020-08-01 11:39:32', '1', '1'),
       ('1406', '2020-08-01 11:39:32', '100002', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '59.00', null, '1', '1', '0.00', '0', '1', '2020-08-01 11:39:32', '1', '1'),
       ('1407', '2020-08-01 11:39:32', '100002', '4', '终极会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '79.00', null, '1', '1', '0.00', '0', '1', '2020-08-01 11:39:32', '1', '1'),
       ('1408', '2020-08-01 11:39:32', '100002', '5', '究极会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        '沃尔玛会员卡', '129.00', null, '1', '1', '0.00', '0', '1', '2020-08-01 11:39:32', '1', '1'),
       ('1409', '2020-08-01 12:09:55', '100002', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '沃尔玛会员卡', '29.00', null, '1', '365', '0.00', '0', '1', '2020-08-01 12:09:55', '1', '1'),
       ('1410', '2020-08-01 12:09:55', '100002', '2', '金卡会员', 'https://oss-tencent.bgniao.cn/api/supremacy_card.png',
        '沃尔玛会员卡', '39.00', null, '1', '365', '0.00', '0', '1', '2020-08-01 12:09:55', '1', '1'),
       ('1411', '2020-08-01 12:09:55', '100002', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '59.00', null, '1', '365', '0.00', '0', '1', '2020-08-01 12:09:55', '1', '1'),
       ('1412', '2020-08-01 12:09:55', '100002', '4', '终极会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '79.00', null, '1', '365', '0.00', '0', '1', '2020-08-01 12:09:55', '1', '1'),
       ('1413', '2020-08-01 12:09:55', '100002', '5', '究极会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        '沃尔玛会员卡', '129.00', null, '1', '365', '0.00', '0', '1', '2020-08-01 12:09:55', '1', '1'),
       ('1414', '2020-08-01 13:34:43', '100002', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '沃尔玛会员卡', '0.01', null, '1', '365', '0.00', '0', '1', '2020-08-01 13:34:43', '1', '1'),
       ('1415', '2020-08-01 13:34:43', '100002', '2', '金卡会员', 'https://oss-tencent.bgniao.cn/api/supremacy_card.png',
        '沃尔玛会员卡', '39.00', null, '1', '365', '0.00', '0', '1', '2020-08-01 13:34:43', '1', '1'),
       ('1416', '2020-08-01 13:34:43', '100002', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '59.00', null, '1', '365', '0.00', '0', '1', '2020-08-01 13:34:43', '1', '1'),
       ('1417', '2020-08-01 13:34:43', '100002', '4', '终极会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '79.00', null, '1', '365', '0.00', '0', '1', '2020-08-01 13:34:43', '1', '1'),
       ('1418', '2020-08-01 13:34:43', '100002', '5', '究极会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        '沃尔玛会员卡', '129.00', null, '1', '365', '0.00', '0', '1', '2020-08-01 13:34:43', '1', '1'),
       ('1419', '2020-08-01 14:38:25', '100002', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '沃尔玛会员卡', '0.01', null, '1', '365', '0.00', '0', '1', '2020-08-01 14:38:25', '1', '1'),
       ('1420', '2020-08-01 14:38:25', '100002', '2', '金卡会员', 'https://oss-tencent.bgniao.cn/api/supremacy_card.png',
        '沃尔玛会员卡', '39.00', null, '1', '365', '0.00', '0', '1', '2020-08-01 14:38:25', '1', '1'),
       ('1421', '2020-08-01 14:38:25', '100002', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '59.00', null, '1', '365', '0.00', '0', '1', '2020-08-01 14:38:25', '1', '1'),
       ('1422', '2020-08-01 14:38:25', '100002', '4', '终极会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '79.00', null, '1', '365', '0.00', '0', '1', '2020-08-01 14:38:25', '1', '1'),
       ('1423', '2020-08-01 14:38:25', '100002', '5', '究极会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        '沃尔玛会员卡', '10000000.00', null, '1', '365', '0.00', '0', '1', '2020-08-03 11:20:07', '0', '1'),
       ('1424', '2020-08-03 11:20:12', '100002', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '沃尔玛会员卡', '1.00', null, '2', '365', '0.00', '0', '1', '2020-08-03 11:20:12', '1', '1'),
       ('1425', '2020-08-03 11:20:12', '100002', '2', '金卡会员', 'https://oss-tencent.bgniao.cn/api/supremacy_card.png',
        '沃尔玛会员卡', '11.00', null, '2', '365', '0.00', '0', '1', '2020-08-03 11:20:12', '1', '1'),
       ('1426', '2020-08-03 11:20:12', '100002', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '11.00', null, '2', '365', '0.00', '0', '1', '2020-08-03 11:20:12', '1', '1'),
       ('1427', '2020-08-03 11:20:12', '100002', '4', '终极会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '11.00', null, '2', '365', '0.00', '0', '1', '2020-08-03 11:20:12', '1', '1'),
       ('1428', '2020-08-03 11:20:12', '100002', '5', '', 'https://oss-tencent.bgniao.cn/api/silver_card.png', '沃尔玛会员卡',
        null, null, '2', '365', '0.00', '0', '1', '2020-08-03 23:58:21', '1', '1'),
       ('1434', '2020-08-03 23:58:38', '100002', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '沃尔玛会员卡', '1.00', null, '2', '365', '0.00', '0', '1', '2020-08-03 23:58:38', '1', '1'),
       ('1435', '2020-08-03 23:58:39', '100002', '2', '金卡会员', 'https://oss-tencent.bgniao.cn/api/supremacy_card.png',
        '沃尔玛会员卡', '11.00', null, '2', '365', '0.00', '0', '1', '2020-08-03 23:58:39', '1', '1'),
       ('1436', '2020-08-03 23:58:39', '100002', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '11.00', null, '2', '365', '0.00', '0', '1', '2020-08-04 00:04:50', '1', '1'),
       ('1437', '2020-08-03 23:58:39', '100002', '4', '终极会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '11.00', null, '2', '365', '0.00', '0', '1', '2020-08-04 00:25:24', '1', '1'),
       ('1438', '2020-08-03 23:58:39', '100002', '5', '究极会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        '沃尔玛会员卡', '12.00', null, '2', '365', '0.00', '0', '1', '2020-08-03 23:59:05', '1', '1'),
       ('1439', '2020-08-04 13:42:06', '100158', '1', '普通会员', null, 'Plus会员', '39.00', null, '1', '365', '0.00', '0',
        '1', '2020-08-04 13:42:06', '1', null),
       ('1440', '2020-08-04 13:42:06', '100158', '2', '黄金会员', null, 'Plus会员', '199.00', null, '1', '365', '0.00', '0',
        '1', '2020-08-04 13:42:06', '1', null),
       ('1441', '2020-08-04 13:42:06', '100158', '3', '钻石会员', null, 'Plus会员', '399.00', null, '1', '365', '0.00', '0',
        '1', '2020-08-04 13:42:06', '1', null),
       ('1442', '2020-08-04 13:42:06', '100158', '4', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '1',
        '2020-08-04 13:42:06', '0', null),
       ('1443', '2020-08-04 13:42:06', '100158', '5', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '1',
        '2020-08-04 13:42:06', '0', null),
       ('1444', '2020-08-04 13:43:10', '100158', '1', '普通会员', null, 'Plus会员', '39.00', null, '1', '365', '0.00', '0',
        '1', '2020-08-04 13:43:10', '1', null),
       ('1445', '2020-08-04 13:43:10', '100158', '2', '黄金会员', null, 'Plus会员', '199.00', null, '1', '365', '0.00', '0',
        '1', '2020-08-04 13:43:10', '1', null),
       ('1446', '2020-08-04 13:43:10', '100158', '3', '钻石会员', null, 'Plus会员', '399.00', null, '1', '365', '0.00', '0',
        '1', '2020-08-04 13:43:10', '1', null),
       ('1447', '2020-08-04 13:43:10', '100158', '4', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '1',
        '2020-08-04 13:43:10', '0', null),
       ('1448', '2020-08-04 13:43:10', '100158', '5', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '1',
        '2020-08-04 13:43:10', '0', null),
       ('1449', '2020-08-04 14:09:07', '100158', '1', '普通会员', null, 'Plus会员', '20.00', null, '2', '365', '0.00', '0',
        '0', '2020-08-04 14:09:07', '1', null),
       ('1450', '2020-08-04 14:09:07', '100158', '2', '黄金会员', null, 'Plus会员', '23.00', null, '2', '365', '0.00', '0',
        '0', '2020-08-04 14:09:07', '1', null),
       ('1451', '2020-08-04 14:09:07', '100158', '3', '钻石会员', null, 'Plus会员', '25.00', null, '2', '365', '0.00', '0',
        '0', '2020-08-04 14:09:07', '1', null),
       ('1452', '2020-08-04 14:09:07', '100158', '4', null, null, 'Plus会员', null, null, '2', '365', '0.00', '0', '0',
        '2020-08-04 14:09:07', '0', null),
       ('1453', '2020-08-04 14:09:07', '100158', '5', null, null, 'Plus会员', null, null, '2', '365', '0.00', '0', '0',
        '2020-08-04 14:09:07', '0', null),
       ('1454', '2020-08-04 20:22:02', '100002', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '沃尔玛会员卡', null, null, '3', '365', '0.01', '0', '1', '2020-08-04 20:22:02', '1', '1'),
       ('1455', '2020-08-04 20:22:02', '100002', '2', '金卡会员', 'https://oss-tencent.bgniao.cn/api/supremacy_card.png',
        '沃尔玛会员卡', null, null, '3', '365', '10000.00', '0', '1', '2020-08-04 20:22:02', '1', '1'),
       ('1456', '2020-08-04 20:22:02', '100002', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', null, null, '3', '365', '20000.00', '0', '1', '2020-08-04 20:22:02', '1', '1'),
       ('1457', '2020-08-04 20:22:02', '100002', '4', '终极会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', null, null, '3', '365', '50000.00', '0', '1', '2020-08-04 20:22:02', '1', '1'),
       ('1458', '2020-08-04 20:22:02', '100002', '5', '究极会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        '沃尔玛会员卡', null, null, '3', '365', '60000.00', '0', '1', '2020-08-04 20:22:02', '1', '1'),
       ('1459', '2020-08-04 20:42:14', '100002', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '沃尔玛会员卡', '1.00', null, '1', '365', '0.00', '0', '1', '2020-08-04 20:42:14', '1', '1'),
       ('1460', '2020-08-04 20:42:14', '100002', '2', '金卡会员', 'https://oss-tencent.bgniao.cn/api/supremacy_card.png',
        '沃尔玛会员卡', '2.00', null, '1', '365', '0.00', '0', '1', '2020-08-04 20:42:14', '1', '1'),
       ('1461', '2020-08-04 20:42:14', '100002', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '3.00', null, '1', '365', '0.00', '0', '1', '2020-08-04 20:42:14', '1', '1'),
       ('1462', '2020-08-04 20:42:14', '100002', '4', '终极会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '4.00', null, '1', '365', '0.00', '0', '1', '2020-08-04 20:42:14', '1', '1'),
       ('1463', '2020-08-04 20:42:14', '100002', '5', '究极会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        '沃尔玛会员卡', '5.00', null, '1', '365', '0.00', '0', '1', '2020-08-04 20:42:14', '1', '1'),
       ('1464', '2020-08-04 20:46:37', '100002', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '沃尔玛会员卡', null, null, '3', '365', '0.02', '0', '1', '2020-08-04 20:46:37', '1', '1'),
       ('1465', '2020-08-04 20:46:37', '100002', '2', '金卡会员', 'https://oss-tencent.bgniao.cn/api/supremacy_card.png',
        '沃尔玛会员卡', null, null, '3', '365', '1.00', '0', '1', '2020-08-04 20:46:37', '1', '1'),
       ('1466', '2020-08-04 20:46:38', '100002', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', null, null, '3', '365', '2.00', '0', '1', '2020-08-04 20:46:38', '1', '1'),
       ('1467', '2020-08-04 20:46:38', '100002', '4', '终极会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', null, null, '3', '365', '3.00', '0', '1', '2020-08-04 20:46:38', '1', '1'),
       ('1468', '2020-08-04 20:46:38', '100002', '5', '究极会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        '沃尔玛会员卡', null, null, '3', '365', '4.00', '0', '1', '2020-08-04 20:46:38', '1', '1'),
       ('1469', '2020-08-04 21:02:52', '100002', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '沃尔玛会员卡', '1.00', null, '1', '365', '0.00', '0', '1', '2020-08-04 21:02:52', '1', '1'),
       ('1470', '2020-08-04 21:02:52', '100002', '2', '金卡会员', 'https://oss-tencent.bgniao.cn/api/supremacy_card.png',
        '沃尔玛会员卡', '2.00', null, '1', '365', '0.00', '0', '1', '2020-08-04 21:02:52', '1', '1'),
       ('1471', '2020-08-04 21:02:52', '100002', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '3.00', null, '1', '365', '0.00', '0', '1', '2020-08-04 21:02:52', '1', '1'),
       ('1472', '2020-08-04 21:02:52', '100002', '4', '终极会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '4.00', null, '1', '365', '0.00', '0', '1', '2020-08-04 21:02:52', '1', '1'),
       ('1473', '2020-08-04 21:02:52', '100002', '5', '究极会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        '沃尔玛会员卡', '5.00', null, '1', '365', '0.00', '0', '1', '2020-08-04 21:02:52', '1', '1'),
       ('1474', '2020-08-04 21:55:42', '100002', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '沃尔玛会员卡', null, null, '3', '365', '0.02', '0', '1', '2020-08-04 21:55:42', '1', '1'),
       ('1475', '2020-08-04 21:55:42', '100002', '2', '金卡会员', 'https://oss-tencent.bgniao.cn/api/supremacy_card.png',
        '沃尔玛会员卡', null, null, '3', '365', '1.00', '0', '1', '2020-08-04 21:55:42', '1', '1'),
       ('1476', '2020-08-04 21:55:42', '100002', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', null, null, '3', '365', '2.00', '0', '1', '2020-08-04 21:55:42', '1', '1'),
       ('1477', '2020-08-04 21:55:42', '100002', '4', '终极会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', null, null, '3', '365', '3.00', '0', '1', '2020-08-04 21:55:42', '1', '1'),
       ('1478', '2020-08-04 21:55:42', '100002', '5', '究极会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        '沃尔玛会员卡', null, null, '3', '365', '4.00', '0', '1', '2020-08-04 21:55:42', '1', '1'),
       ('1479', '2020-08-05 08:46:08', '100002', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '沃尔玛会员卡', null, null, '3', '365', '0.02', '0', '1', '2020-08-05 08:46:08', '1', '1'),
       ('1480', '2020-08-05 08:46:09', '100002', '2', '金卡会员', 'https://oss-tencent.bgniao.cn/api/supremacy_card.png',
        '沃尔玛会员卡', null, null, '3', '365', '1.00', '0', '1', '2020-08-05 08:46:09', '1', '1'),
       ('1481', '2020-08-05 08:46:09', '100002', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', null, null, '3', '365', '2.00', '0', '1', '2020-08-05 08:46:09', '1', '1'),
       ('1482', '2020-08-05 08:46:09', '100002', '4', '终极会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', null, null, '3', '365', '3.00', '0', '1', '2020-08-05 08:46:09', '1', '1'),
       ('1483', '2020-08-05 08:46:09', '100002', '5', '究极会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        '沃尔玛会员卡', null, null, '3', '365', '4.00', '0', '1', '2020-08-05 08:46:09', '1', '1');
INSERT INTO `t_member_card_info`
VALUES ('1484', '2020-08-07 21:38:47', '100159', '1', '普通会员', null, 'Plus会员', '39.00', null, '1', '365', '0.00', '0',
        '0', '2020-08-07 21:38:47', '1', null),
       ('1485', '2020-08-07 21:38:47', '100159', '2', '黄金会员', null, 'Plus会员', '199.00', null, '1', '365', '0.00', '0',
        '0', '2020-08-07 21:38:47', '1', null),
       ('1486', '2020-08-07 21:38:47', '100159', '3', '钻石会员', null, 'Plus会员', '399.00', null, '1', '365', '0.00', '0',
        '0', '2020-08-07 21:38:47', '1', null),
       ('1487', '2020-08-07 21:38:47', '100159', '4', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-08-07 21:38:47', '0', null),
       ('1488', '2020-08-07 21:38:47', '100159', '5', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-08-07 21:38:47', '0', null),
       ('1489', '2020-08-07 22:07:16', '100002', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '沃尔玛会员卡', '0.02', null, '1', '365', '0.00', '0', '1', '2020-08-07 22:07:16', '1', '1'),
       ('1490', '2020-08-07 22:07:17', '100002', '2', '金卡会员', 'https://oss-tencent.bgniao.cn/api/supremacy_card.png',
        '沃尔玛会员卡', '1.00', null, '1', '365', '0.00', '0', '1', '2020-08-07 22:07:17', '1', '1'),
       ('1491', '2020-08-07 22:07:17', '100002', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '2.00', null, '1', '365', '0.00', '0', '1', '2020-08-07 22:07:17', '1', '1'),
       ('1492', '2020-08-07 22:07:17', '100002', '4', '终极会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '3.00', null, '1', '365', '0.00', '0', '1', '2020-08-07 22:07:17', '1', '1'),
       ('1493', '2020-08-07 22:07:17', '100002', '5', '究极会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        '沃尔玛会员卡', '4.00', null, '1', '365', '0.00', '0', '1', '2020-08-07 22:07:17', '1', '1'),
       ('1494', '2020-08-08 11:16:38', '100160', '1', '普通会员', null, 'Plus会员', '39.00', null, '1', '365', '0.00', '0',
        '0', '2020-08-08 11:16:38', '1', null),
       ('1495', '2020-08-08 11:16:38', '100160', '2', '黄金会员', null, 'Plus会员', '199.00', null, '1', '365', '0.00', '0',
        '0', '2020-08-08 11:16:38', '1', null),
       ('1496', '2020-08-08 11:16:38', '100160', '3', '钻石会员', null, 'Plus会员', '399.00', null, '1', '365', '0.00', '0',
        '0', '2020-08-08 11:16:38', '1', null),
       ('1497', '2020-08-08 11:16:38', '100160', '4', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-08-08 11:16:38', '0', null),
       ('1498', '2020-08-08 11:16:38', '100160', '5', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-08-08 11:16:38', '0', null),
       ('1499', '2020-08-11 21:37:09', '100161', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        'Plus会员', '39.00', null, '1', '365', '0.00', '0', '0', '2020-08-11 21:37:09', '1', null),
       ('1500', '2020-08-11 21:37:09', '100161', '2', '黄金会员', 'https://oss-tencent.bgniao.cn/api/general_card.png',
        'Plus会员', '199.00', null, '1', '365', '0.00', '0', '0', '2020-08-11 21:37:09', '1', null),
       ('1501', '2020-08-11 21:37:09', '100161', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        'Plus会员', '399.00', null, '1', '365', '0.00', '0', '0', '2020-08-11 21:37:09', '1', null),
       ('1502', '2020-08-11 21:37:09', '100161', '4', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-08-11 21:37:09', '0', null),
       ('1503', '2020-08-11 21:37:09', '100161', '5', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-08-11 21:37:09', '0', null),
       ('1504', '2020-08-12 10:57:22', '100002', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '沃尔玛会员卡', '10.00', null, '2', '365', '0.00', '0', '1', '2020-08-12 10:57:22', '1', '1'),
       ('1505', '2020-08-12 10:57:22', '100002', '2', '金卡会员', 'https://oss-tencent.bgniao.cn/api/supremacy_card.png',
        '沃尔玛会员卡', '20.00', null, '2', '365', '0.00', '0', '1', '2020-08-12 10:57:22', '1', '1'),
       ('1506', '2020-08-12 10:57:22', '100002', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '30.00', null, '2', '365', '0.00', '0', '1', '2020-08-12 10:57:22', '1', '1'),
       ('1507', '2020-08-12 10:57:22', '100002', '4', '终极会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '40.00', null, '2', '365', '0.00', '0', '1', '2020-08-12 10:57:22', '1', '1'),
       ('1508', '2020-08-12 10:57:22', '100002', '5', '究极会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        '沃尔玛会员卡', '50.00', null, '2', '365', '0.00', '0', '1', '2020-08-12 10:57:22', '1', '1'),
       ('1509', '2020-08-12 11:03:53', '100002', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '沃尔玛会员卡', '10.00', null, '2', '1', '0.00', '0', '1', '2020-08-12 11:03:53', '1', '1'),
       ('1510', '2020-08-12 11:03:53', '100002', '2', '金卡会员', 'https://oss-tencent.bgniao.cn/api/supremacy_card.png',
        '沃尔玛会员卡', '20.00', null, '2', '1', '0.00', '0', '1', '2020-08-12 11:03:53', '1', '1'),
       ('1511', '2020-08-12 11:03:53', '100002', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '30.00', null, '2', '1', '0.00', '0', '1', '2020-08-12 11:03:53', '1', '1'),
       ('1512', '2020-08-12 11:03:53', '100002', '4', '终极会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '40.00', null, '2', '1', '0.00', '0', '1', '2020-08-12 11:03:53', '1', '1'),
       ('1513', '2020-08-12 11:03:53', '100002', '5', '究极会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        '沃尔玛会员卡', '50.00', null, '2', '1', '0.00', '0', '1', '2020-08-12 11:03:53', '1', '1'),
       ('1514', '2020-08-12 15:00:57', '100002', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '沃尔玛会员卡', '10.00', null, '1', '1', '0.00', '0', '1', '2020-08-12 15:00:57', '1', '1'),
       ('1515', '2020-08-12 15:00:57', '100002', '2', '金卡会员', 'https://oss-tencent.bgniao.cn/api/supremacy_card.png',
        '沃尔玛会员卡', '20.00', null, '1', '1', '0.00', '0', '1', '2020-08-12 15:00:57', '1', '1'),
       ('1516', '2020-08-12 15:00:57', '100002', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '30.00', null, '1', '1', '0.00', '0', '1', '2020-08-12 15:00:57', '1', '1'),
       ('1517', '2020-08-12 15:00:57', '100002', '4', '终极会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '沃尔玛会员卡', '40.00', null, '1', '1', '0.00', '0', '1', '2020-08-12 15:00:57', '1', '1'),
       ('1518', '2020-08-12 15:00:57', '100002', '5', '究极会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        '沃尔玛会员卡', '50.00', null, '1', '1', '0.00', '0', '1', '2020-08-12 15:00:57', '1', '1'),
       ('1519', '2020-08-16 10:05:26', '100162', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        'Plus会员', '39.00', null, '1', '365', '0.00', '0', '0', '2020-08-16 10:05:26', '1', null),
       ('1520', '2020-08-16 10:05:26', '100162', '2', '黄金会员', 'https://oss-tencent.bgniao.cn/api/general_card.png',
        'Plus会员', '199.00', null, '1', '365', '0.00', '0', '0', '2020-08-16 10:05:26', '1', null),
       ('1521', '2020-08-16 10:05:26', '100162', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        'Plus会员', '399.00', null, '1', '365', '0.00', '0', '0', '2020-08-16 10:05:26', '1', null),
       ('1522', '2020-08-16 10:05:26', '100162', '4', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-08-16 10:05:26', '0', null),
       ('1523', '2020-08-16 10:05:26', '100162', '5', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-08-16 10:05:26', '0', null),
       ('1524', '2020-08-16 10:05:56', '100162', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        'Plus会员', '39.00', null, '1', '365', '0.00', '0', '0', '2020-08-16 10:05:56', '1', null),
       ('1525', '2020-08-16 10:05:56', '100162', '2', '黄金会员', 'https://oss-tencent.bgniao.cn/api/general_card.png',
        'Plus会员', '199.00', null, '1', '365', '0.00', '0', '0', '2020-08-16 10:05:56', '1', null),
       ('1526', '2020-08-16 10:05:56', '100162', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        'Plus会员', '399.00', null, '1', '365', '0.00', '0', '0', '2020-08-16 10:05:56', '1', null),
       ('1527', '2020-08-16 10:05:56', '100162', '4', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-08-16 10:05:56', '0', null),
       ('1528', '2020-08-16 10:05:56', '100162', '5', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-08-16 10:05:56', '0', null),
       ('1529', '2020-08-16 10:43:43', '100162', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        'Plus会员', '39.00', null, '1', '365', '0.00', '0', '0', '2020-08-16 10:43:43', '1', null),
       ('1530', '2020-08-16 10:43:43', '100162', '2', '黄金会员', 'https://oss-tencent.bgniao.cn/api/general_card.png',
        'Plus会员', '199.00', null, '1', '365', '0.00', '0', '0', '2020-08-16 10:43:43', '1', null),
       ('1531', '2020-08-16 10:43:43', '100162', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        'Plus会员', '399.00', null, '1', '365', '0.00', '0', '0', '2020-08-16 10:43:43', '1', null),
       ('1532', '2020-08-16 10:43:43', '100162', '4', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-08-16 10:43:43', '0', null),
       ('1533', '2020-08-16 10:43:43', '100162', '5', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-08-16 10:43:43', '0', null),
       ('1534', '2020-08-16 10:44:29', '100162', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        'Plus会员', '39.00', null, '1', '365', '0.00', '0', '0', '2020-08-16 10:44:29', '1', null),
       ('1535', '2020-08-16 10:44:29', '100162', '2', '黄金会员', 'https://oss-tencent.bgniao.cn/api/general_card.png',
        'Plus会员', '199.00', null, '1', '365', '0.00', '0', '0', '2020-08-16 10:44:29', '1', null),
       ('1536', '2020-08-16 10:44:29', '100162', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        'Plus会员', '399.00', null, '1', '365', '0.00', '0', '0', '2020-08-16 10:44:29', '1', null),
       ('1537', '2020-08-16 10:44:29', '100162', '4', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-08-16 10:44:29', '0', null),
       ('1538', '2020-08-16 10:44:29', '100162', '5', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-08-16 10:44:29', '0', null),
       ('1539', '2020-08-16 10:44:42', '100162', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        'Plus会员', '39.00', null, '1', '365', '0.00', '0', '0', '2020-08-16 10:44:42', '1', null),
       ('1540', '2020-08-16 10:44:42', '100162', '2', '黄金会员', 'https://oss-tencent.bgniao.cn/api/general_card.png',
        'Plus会员', '199.00', null, '1', '365', '0.00', '0', '0', '2020-08-16 10:44:42', '1', null),
       ('1541', '2020-08-16 10:44:42', '100162', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        'Plus会员', '399.00', null, '1', '365', '0.00', '0', '0', '2020-08-16 10:44:42', '1', null),
       ('1542', '2020-08-16 10:44:42', '100162', '4', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-08-16 10:44:42', '0', null),
       ('1543', '2020-08-16 10:44:42', '100162', '5', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-08-16 10:44:42', '0', null),
       ('1544', '2020-08-16 10:51:13', '100162', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        'Plus会员', '39.00', null, '1', '365', '0.00', '0', '0', '2020-08-16 10:51:13', '1', null),
       ('1545', '2020-08-16 10:51:13', '100162', '2', '黄金会员', 'https://oss-tencent.bgniao.cn/api/general_card.png',
        'Plus会员', '199.00', null, '1', '365', '0.00', '0', '0', '2020-08-16 10:51:13', '1', null),
       ('1546', '2020-08-16 10:51:13', '100162', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        'Plus会员', '399.00', null, '1', '365', '0.00', '0', '0', '2020-08-16 10:51:13', '1', null),
       ('1547', '2020-08-16 10:51:13', '100162', '4', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-08-16 10:51:13', '0', null),
       ('1548', '2020-08-16 10:51:13', '100162', '5', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-08-16 10:51:13', '0', null),
       ('1549', '2020-08-16 20:07:02', '100163', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        'Plus会员', '39.00', null, '1', '365', '0.00', '0', '0', '2020-08-16 20:07:02', '1', null),
       ('1550', '2020-08-16 20:07:02', '100163', '2', '黄金会员', 'https://oss-tencent.bgniao.cn/api/general_card.png',
        'Plus会员', '199.00', null, '1', '365', '0.00', '0', '0', '2020-08-16 20:07:02', '1', null),
       ('1551', '2020-08-16 20:07:02', '100163', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        'Plus会员', '399.00', null, '1', '365', '0.00', '0', '0', '2020-08-16 20:07:02', '1', null),
       ('1552', '2020-08-16 20:07:02', '100163', '4', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-08-16 20:07:02', '0', null),
       ('1553', '2020-08-16 20:07:02', '100163', '5', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-08-16 20:07:02', '0', null),
       ('1554', '2020-08-17 13:13:56', '100002', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '还好尔玛会员卡', '10.00', null, '1', '1', '0.00', '0', '1', '2020-08-17 13:13:56', '1', '1'),
       ('1555', '2020-08-17 13:13:56', '100002', '2', '金卡会员', 'https://oss-tencent.bgniao.cn/api/supremacy_card.png',
        '还好尔玛会员卡', '20.00', null, '1', '1', '0.00', '0', '1', '2020-08-17 13:13:56', '1', '1'),
       ('1556', '2020-08-17 13:13:56', '100002', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '还好尔玛会员卡', '30.00', null, '1', '1', '0.00', '0', '1', '2020-08-17 13:13:56', '1', '1'),
       ('1557', '2020-08-17 13:13:56', '100002', '4', '终极会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '还好尔玛会员卡', '40.00', null, '1', '1', '0.00', '0', '1', '2020-08-17 13:13:56', '1', '1'),
       ('1558', '2020-08-17 13:13:56', '100002', '5', '究极会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        '还好尔玛会员卡', '50.00', null, '1', '1', '0.00', '0', '1', '2020-08-17 13:13:56', '1', '1'),
       ('1559', '2020-08-17 13:15:13', '100002', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        '还好尔玛会员卡', '0.01', null, '1', '1', '0.00', '0', '0', '2020-08-17 13:15:13', '1', '1'),
       ('1560', '2020-08-17 13:15:13', '100002', '2', '金卡会员', 'https://oss-tencent.bgniao.cn/api/supremacy_card.png',
        '还好尔玛会员卡', '20.00', null, '1', '1', '0.00', '0', '0', '2020-08-17 13:15:13', '1', '1'),
       ('1561', '2020-08-17 13:15:13', '100002', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '还好尔玛会员卡', '30.00', null, '1', '1', '0.00', '0', '0', '2020-08-17 13:15:13', '1', '1'),
       ('1562', '2020-08-17 13:15:13', '100002', '4', '终极会员', 'https://oss-tencent.bgniao.cn/api/gold_card.png',
        '还好尔玛会员卡', '40.00', null, '1', '1', '0.00', '0', '0', '2020-08-17 13:15:13', '1', '1'),
       ('1563', '2020-08-17 13:15:13', '100002', '5', '究极会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        '还好尔玛会员卡', '50.00', null, '1', '1', '0.00', '0', '0', '2020-08-17 13:15:13', '1', '1'),
       ('1564', '2020-09-01 20:46:29', '100164', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        'Plus会员', '39.00', null, '1', '365', '0.00', '0', '0', '2020-09-01 20:46:29', '1', null),
       ('1565', '2020-09-01 20:46:29', '100164', '2', '黄金会员', 'https://oss-tencent.bgniao.cn/api/general_card.png',
        'Plus会员', '199.00', null, '1', '365', '0.00', '0', '0', '2020-09-01 20:46:29', '1', null),
       ('1566', '2020-09-01 20:46:29', '100164', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        'Plus会员', '399.00', null, '1', '365', '0.00', '0', '0', '2020-09-01 20:46:29', '1', null),
       ('1567', '2020-09-01 20:46:30', '100164', '4', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-09-01 20:46:30', '0', null),
       ('1568', '2020-09-01 20:46:30', '100164', '5', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-09-01 20:46:30', '0', null),
       ('1569', '2020-09-02 13:17:09', '100165', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        'Plus会员', '39.00', null, '1', '365', '0.00', '0', '0', '2020-09-02 13:17:09', '1', null),
       ('1570', '2020-09-02 13:17:09', '100165', '2', '黄金会员', 'https://oss-tencent.bgniao.cn/api/general_card.png',
        'Plus会员', '199.00', null, '1', '365', '0.00', '0', '0', '2020-09-02 13:17:09', '1', null),
       ('1571', '2020-09-02 13:17:09', '100165', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        'Plus会员', '399.00', null, '1', '365', '0.00', '0', '0', '2020-09-02 13:17:09', '1', null),
       ('1572', '2020-09-02 13:17:09', '100165', '4', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-09-02 13:17:09', '0', null),
       ('1573', '2020-09-02 13:17:09', '100165', '5', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-09-02 13:17:09', '0', null),
       ('1574', '2020-09-02 13:19:07', '100166', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        'Plus会员', '39.00', null, '1', '365', '0.00', '0', '0', '2020-09-02 13:19:07', '1', null),
       ('1575', '2020-09-02 13:19:07', '100166', '2', '黄金会员', 'https://oss-tencent.bgniao.cn/api/general_card.png',
        'Plus会员', '199.00', null, '1', '365', '0.00', '0', '0', '2020-09-02 13:19:07', '1', null),
       ('1576', '2020-09-02 13:19:07', '100166', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        'Plus会员', '399.00', null, '1', '365', '0.00', '0', '0', '2020-09-02 13:19:07', '1', null),
       ('1577', '2020-09-02 13:19:07', '100166', '4', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-09-02 13:19:07', '0', null),
       ('1578', '2020-09-02 13:19:07', '100166', '5', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-09-02 13:19:07', '0', null),
       ('1579', '2020-09-03 09:13:51', '100167', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        'Plus会员', '39.00', null, '1', '365', '0.00', '0', '0', '2020-09-03 09:13:51', '1', null),
       ('1580', '2020-09-03 09:13:51', '100167', '2', '黄金会员', 'https://oss-tencent.bgniao.cn/api/general_card.png',
        'Plus会员', '199.00', null, '1', '365', '0.00', '0', '0', '2020-09-03 09:13:51', '1', null),
       ('1581', '2020-09-03 09:13:51', '100167', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        'Plus会员', '399.00', null, '1', '365', '0.00', '0', '0', '2020-09-03 09:13:51', '1', null),
       ('1582', '2020-09-03 09:13:51', '100167', '4', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-09-03 09:13:51', '0', null),
       ('1583', '2020-09-03 09:13:51', '100167', '5', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-09-03 09:13:51', '0', null);
INSERT INTO `t_member_card_info`
VALUES ('1584', '2020-09-04 20:45:02', '100168', '1', '普通会员', 'https://oss-tencent.bgniao.cn/api/silver_card.png',
        'Plus会员', '39.00', null, '1', '365', '0.00', '0', '0', '2020-09-04 20:45:02', '1', null),
       ('1585', '2020-09-04 20:45:02', '100168', '2', '黄金会员', 'https://oss-tencent.bgniao.cn/api/general_card.png',
        'Plus会员', '199.00', null, '1', '365', '0.00', '0', '0', '2020-09-04 20:45:02', '1', null),
       ('1586', '2020-09-04 20:45:02', '100168', '3', '钻石会员', 'https://oss-tencent.bgniao.cn/api/platinum_card.png',
        'Plus会员', '399.00', null, '1', '365', '0.00', '0', '0', '2020-09-04 20:45:02', '1', null),
       ('1587', '2020-09-04 20:45:02', '100168', '4', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-09-04 20:45:02', '0', null),
       ('1588', '2020-09-04 20:45:02', '100168', '5', null, null, 'Plus会员', null, null, '1', '365', '0.00', '0', '0',
        '2020-09-04 20:45:02', '0', null);
COMMIT;

-- ----------------------------
-- Table structure for t_member_card_privilege
-- ----------------------------
DROP TABLE IF EXISTS `t_member_card_privilege`;
CREATE TABLE `t_member_card_privilege`
(
    `id`             bigint                                                        NOT NULL AUTO_INCREMENT,
    `create_time`    datetime                                                      NULL DEFAULT NULL COMMENT '创建时间',
    `tenant_id`      varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL DEFAULT NULL COMMENT '租户id',
    `icon`           varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '权益图标',
    `privilege_name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL DEFAULT NULL COMMENT '权益名称',
    `illustrate`     varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '权益说明',
    `p_type`         varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '特权类型 0-自定义权益 1-商品权益 2-包邮权益 3-积分倍数权益 4-专属客服权益 5-优先发货 6-急速售后 ',
    `is_allow_del`   tinyint(1)                                                    NULL DEFAULT NULL COMMENT '是否允许删除 0-不允许 1-允许',
    `is_open`        tinyint(1)                                                    NULL DEFAULT NULL COMMENT '特权开关 0-关闭  1-开启',
    `is_rule`        varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '是否有多个权益值选择 0-否 1-是',
    `def_value`      decimal(10, 2)                                                NULL DEFAULT NULL COMMENT '默认值(可以是折扣值或者其他值,目前只有p_type=1时代表未添加为权益商品的商品的默认值)',
    `is_deleted`     tinyint(1)                                                    NULL DEFAULT NULL COMMENT '删除状态：0->未删除；1->已删除',
    `update_time`    datetime                                                      NULL DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`)
)
    ENGINE = InnoDB
    DEFAULT CHARACTER SET = utf8mb4
    COLLATE = utf8mb4_0900_ai_ci
    COMMENT ='会员卡权益表'
    AUTO_INCREMENT = 181
;

-- ----------------------------
-- Records of t_member_card_privilege
-- ----------------------------
BEGIN;
INSERT INTO `t_member_card_privilege`
VALUES ('1', '2020-05-30 22:25:26', '100002', '', '商品折扣', '商品折扣', '1', '0', '1', '0', null, '0', '2020-07-27 10:05:26'),
       ('4', '2020-07-04 10:19:00', '100002', '', '积分加倍', '购买商品获得的积分加倍', '3', '0', '1', null, null, '0',
        '2020-07-21 22:14:16'),
       ('5', '2020-07-06 23:49:11', '100002', '', '物流优惠', '物流配送方式订单享受包邮免配送费', '2', '0', '1', null, null, '0',
        '2020-07-21 22:14:18'),
       ('6', '2020-07-06 23:52:47', '100002', '', '优先发货', '订单优先发货', '5', '0', '1', null, null, '0',
        '2020-07-21 22:14:18'),
       ('7', '2020-07-06 23:52:50', '100002', '', '急速售后', '申请维权时，系统自动同意维权申请，无需等待人工审核', '6', '0', '1', null, null, '0',
        '2020-07-21 22:14:19'),
       ('8', '2020-07-06 23:52:52', '100002', '', '专属客服', '享受专属客服1对1接待', '4', '0', '1', null, null, '0',
        '2020-07-25 16:48:10'),
       ('71', '2020-08-01 11:13:09', '100002',
        'https://medusa-small-file-1253272780.cos.ap-shanghai.myqcloud.com/gruul/20200801/162bc24cfab4419db0c01b5fde47d561.jpg',
        '超级会员权', '退换货', '0', '1', '1', null, null, '0', '2020-08-01 11:13:55'),
       ('84', '2020-08-04 13:42:05', '100158', null, '商品折扣', '商品折扣', '1', '0', '1', null, null, '0',
        '2020-08-04 13:42:05'),
       ('85', '2020-08-04 13:42:05', '100158', null, '积分加倍', '购买商品获得的积分加倍', '3', '0', '1', null, null, '0',
        '2020-08-04 13:42:05'),
       ('86', '2020-08-04 13:42:05', '100158', null, '物流优惠', '物流配送方式订单享受包邮免配送费', '2', '0', '1', null, null, '0',
        '2020-08-04 13:42:05'),
       ('87', '2020-08-04 13:42:05', '100158', null, '优先发货', '订单优先发货', '5', '0', '1', null, null, '0',
        '2020-08-04 13:42:05'),
       ('88', '2020-08-04 13:42:05', '100158', null, '急速售后', '申请维权时，系统自动同意维权申请，无需等待人工审核', '6', '0', '1', null, null,
        '0', '2020-08-04 13:42:05'),
       ('89', '2020-08-04 13:42:06', '100158', null, '专属客服', '享受专属客服1对1接待', '4', '0', '1', null, null, '0',
        '2020-08-04 13:42:06'),
       ('90', '2020-08-05 08:41:23', '100002', null, null, null, '0', '1', '1', null, null, '0', '2020-08-05 08:41:23'),
       ('91', '2020-08-07 21:38:47', '100159', null, '商品折扣', '商品折扣', '1', '0', '1', null, null, '0',
        '2020-08-07 21:38:47'),
       ('92', '2020-08-07 21:38:47', '100159', null, '积分加倍', '购买商品获得的积分加倍', '3', '0', '1', null, null, '0',
        '2020-08-07 21:38:47'),
       ('93', '2020-08-07 21:38:47', '100159', null, '物流优惠', '物流配送方式订单享受包邮免配送费', '2', '0', '1', null, null, '0',
        '2020-08-07 21:38:47'),
       ('94', '2020-08-07 21:38:47', '100159', null, '优先发货', '订单优先发货', '5', '0', '1', null, null, '0',
        '2020-08-07 21:38:47'),
       ('95', '2020-08-07 21:38:47', '100159', null, '急速售后', '申请维权时，系统自动同意维权申请，无需等待人工审核', '6', '0', '1', null, null,
        '0', '2020-08-07 21:38:47'),
       ('96', '2020-08-07 21:38:47', '100159', null, '专属客服', '享受专属客服1对1接待', '4', '0', '1', null, null, '0',
        '2020-08-07 21:38:47'),
       ('97', '2020-08-08 11:16:38', '100160', null, '商品折扣', '商品折扣', '1', '0', '1', null, null, '0',
        '2020-08-08 11:16:38'),
       ('98', '2020-08-08 11:16:38', '100160', null, '积分加倍', '购买商品获得的积分加倍', '3', '0', '1', null, null, '0',
        '2020-08-08 11:16:38'),
       ('99', '2020-08-08 11:16:38', '100160', null, '物流优惠', '物流配送方式订单享受包邮免配送费', '2', '0', '1', null, null, '0',
        '2020-08-08 11:16:38'),
       ('100', '2020-08-08 11:16:38', '100160', null, '优先发货', '订单优先发货', '5', '0', '1', null, null, '0',
        '2020-08-08 11:16:38'),
       ('101', '2020-08-08 11:16:38', '100160', null, '急速售后', '申请维权时，系统自动同意维权申请，无需等待人工审核', '6', '0', '1', null, null,
        '0', '2020-08-08 11:16:38'),
       ('102', '2020-08-08 11:16:38', '100160', null, '专属客服', '享受专属客服1对1接待', '4', '0', '1', null, null, '0',
        '2020-08-08 11:16:38'),
       ('103', '2020-08-11 21:37:08', '100161', null, '商品折扣', '商品折扣', '1', '0', '1', null, null, '0',
        '2020-08-11 21:37:08'),
       ('104', '2020-08-11 21:37:08', '100161', null, '积分加倍', '购买商品获得的积分加倍', '3', '0', '1', null, null, '0',
        '2020-08-11 21:37:08'),
       ('105', '2020-08-11 21:37:08', '100161', null, '物流优惠', '物流配送方式订单享受包邮免配送费', '2', '0', '1', null, null, '0',
        '2020-08-11 21:37:08'),
       ('106', '2020-08-11 21:37:08', '100161', null, '优先发货', '订单优先发货', '5', '0', '1', null, null, '0',
        '2020-08-11 21:37:08'),
       ('107', '2020-08-11 21:37:08', '100161', null, '急速售后', '申请维权时，系统自动同意维权申请，无需等待人工审核', '6', '0', '1', null, null,
        '0', '2020-08-11 21:37:08'),
       ('108', '2020-08-11 21:37:09', '100161', null, '专属客服', '享受专属客服1对1接待', '4', '0', '1', null, null, '0',
        '2020-08-11 21:37:09'),
       ('109', '2020-08-16 10:05:26', '100162', null, '商品折扣', '商品折扣', '1', '0', '1', null, null, '0',
        '2020-08-16 10:05:26'),
       ('110', '2020-08-16 10:05:26', '100162', null, '积分加倍', '购买商品获得的积分加倍', '3', '0', '1', null, null, '0',
        '2020-08-16 10:05:26'),
       ('111', '2020-08-16 10:05:26', '100162', null, '物流优惠', '物流配送方式订单享受包邮免配送费', '2', '0', '1', null, null, '0',
        '2020-08-16 10:05:26'),
       ('112', '2020-08-16 10:05:26', '100162', null, '优先发货', '订单优先发货', '5', '0', '1', null, null, '0',
        '2020-08-16 10:05:26'),
       ('113', '2020-08-16 10:05:26', '100162', null, '急速售后', '申请维权时，系统自动同意维权申请，无需等待人工审核', '6', '0', '1', null, null,
        '0', '2020-08-16 10:05:26'),
       ('114', '2020-08-16 10:05:26', '100162', null, '专属客服', '享受专属客服1对1接待', '4', '0', '1', null, null, '0',
        '2020-08-16 10:05:26'),
       ('115', '2020-08-16 10:05:56', '100162', null, '商品折扣', '商品折扣', '1', '0', '1', null, null, '0',
        '2020-08-16 10:05:56'),
       ('116', '2020-08-16 10:05:56', '100162', null, '积分加倍', '购买商品获得的积分加倍', '3', '0', '1', null, null, '0',
        '2020-08-16 10:05:56'),
       ('117', '2020-08-16 10:05:56', '100162', null, '物流优惠', '物流配送方式订单享受包邮免配送费', '2', '0', '1', null, null, '0',
        '2020-08-16 10:05:56'),
       ('118', '2020-08-16 10:05:56', '100162', null, '优先发货', '订单优先发货', '5', '0', '1', null, null, '0',
        '2020-08-16 10:05:56'),
       ('119', '2020-08-16 10:05:56', '100162', null, '急速售后', '申请维权时，系统自动同意维权申请，无需等待人工审核', '6', '0', '1', null, null,
        '0', '2020-08-16 10:05:56'),
       ('120', '2020-08-16 10:05:56', '100162', null, '专属客服', '享受专属客服1对1接待', '4', '0', '1', null, null, '0',
        '2020-08-16 10:05:56'),
       ('121', '2020-08-16 10:43:42', '100162', null, '商品折扣', '商品折扣', '1', '0', '1', null, null, '0',
        '2020-08-16 10:43:42'),
       ('122', '2020-08-16 10:43:42', '100162', null, '积分加倍', '购买商品获得的积分加倍', '3', '0', '1', null, null, '0',
        '2020-08-16 10:43:42'),
       ('123', '2020-08-16 10:43:42', '100162', null, '物流优惠', '物流配送方式订单享受包邮免配送费', '2', '0', '1', null, null, '0',
        '2020-08-16 10:43:42'),
       ('124', '2020-08-16 10:43:42', '100162', null, '优先发货', '订单优先发货', '5', '0', '1', null, null, '0',
        '2020-08-16 10:43:42'),
       ('125', '2020-08-16 10:43:42', '100162', null, '急速售后', '申请维权时，系统自动同意维权申请，无需等待人工审核', '6', '0', '1', null, null,
        '0', '2020-08-16 10:43:42'),
       ('126', '2020-08-16 10:43:42', '100162', null, '专属客服', '享受专属客服1对1接待', '4', '0', '1', null, null, '0',
        '2020-08-16 10:43:42'),
       ('127', '2020-08-16 10:44:29', '100162', null, '商品折扣', '商品折扣', '1', '0', '1', null, null, '0',
        '2020-08-16 10:44:29'),
       ('128', '2020-08-16 10:44:29', '100162', null, '积分加倍', '购买商品获得的积分加倍', '3', '0', '1', null, null, '0',
        '2020-08-16 10:44:29'),
       ('129', '2020-08-16 10:44:29', '100162', null, '物流优惠', '物流配送方式订单享受包邮免配送费', '2', '0', '1', null, null, '0',
        '2020-08-16 10:44:29'),
       ('130', '2020-08-16 10:44:29', '100162', null, '优先发货', '订单优先发货', '5', '0', '1', null, null, '0',
        '2020-08-16 10:44:29'),
       ('131', '2020-08-16 10:44:29', '100162', null, '急速售后', '申请维权时，系统自动同意维权申请，无需等待人工审核', '6', '0', '1', null, null,
        '0', '2020-08-16 10:44:29'),
       ('132', '2020-08-16 10:44:29', '100162', null, '专属客服', '享受专属客服1对1接待', '4', '0', '1', null, null, '0',
        '2020-08-16 10:44:29'),
       ('133', '2020-08-16 10:44:42', '100162', null, '商品折扣', '商品折扣', '1', '0', '1', null, null, '0',
        '2020-08-16 10:44:42'),
       ('134', '2020-08-16 10:44:42', '100162', null, '积分加倍', '购买商品获得的积分加倍', '3', '0', '1', null, null, '0',
        '2020-08-16 10:44:42'),
       ('135', '2020-08-16 10:44:42', '100162', null, '物流优惠', '物流配送方式订单享受包邮免配送费', '2', '0', '1', null, null, '0',
        '2020-08-16 10:44:42'),
       ('136', '2020-08-16 10:44:42', '100162', null, '优先发货', '订单优先发货', '5', '0', '1', null, null, '0',
        '2020-08-16 10:44:42'),
       ('137', '2020-08-16 10:44:42', '100162', null, '急速售后', '申请维权时，系统自动同意维权申请，无需等待人工审核', '6', '0', '1', null, null,
        '0', '2020-08-16 10:44:42'),
       ('138', '2020-08-16 10:44:42', '100162', null, '专属客服', '享受专属客服1对1接待', '4', '0', '1', null, null, '0',
        '2020-08-16 10:44:42'),
       ('139', '2020-08-16 10:51:13', '100162', null, '商品折扣', '商品折扣', '1', '0', '1', null, null, '0',
        '2020-08-16 10:51:13'),
       ('140', '2020-08-16 10:51:13', '100162', null, '积分加倍', '购买商品获得的积分加倍', '3', '0', '1', null, null, '0',
        '2020-08-16 10:51:13'),
       ('141', '2020-08-16 10:51:13', '100162', null, '物流优惠', '物流配送方式订单享受包邮免配送费', '2', '0', '1', null, null, '0',
        '2020-08-16 10:51:13'),
       ('142', '2020-08-16 10:51:13', '100162', null, '优先发货', '订单优先发货', '5', '0', '1', null, null, '0',
        '2020-08-16 10:51:13'),
       ('143', '2020-08-16 10:51:13', '100162', null, '急速售后', '申请维权时，系统自动同意维权申请，无需等待人工审核', '6', '0', '1', null, null,
        '0', '2020-08-16 10:51:13'),
       ('144', '2020-08-16 10:51:13', '100162', null, '专属客服', '享受专属客服1对1接待', '4', '0', '1', null, null, '0',
        '2020-08-16 10:51:13'),
       ('145', '2020-08-16 20:07:02', '100163', null, '商品折扣', '商品折扣', '1', '0', '1', null, null, '0',
        '2020-08-16 20:07:02'),
       ('146', '2020-08-16 20:07:02', '100163', null, '积分加倍', '购买商品获得的积分加倍', '3', '0', '1', null, null, '0',
        '2020-08-16 20:07:02'),
       ('147', '2020-08-16 20:07:02', '100163', null, '物流优惠', '物流配送方式订单享受包邮免配送费', '2', '0', '1', null, null, '0',
        '2020-08-16 20:07:02'),
       ('148', '2020-08-16 20:07:02', '100163', null, '优先发货', '订单优先发货', '5', '0', '1', null, null, '0',
        '2020-08-16 20:07:02'),
       ('149', '2020-08-16 20:07:02', '100163', null, '急速售后', '申请维权时，系统自动同意维权申请，无需等待人工审核', '6', '0', '1', null, null,
        '0', '2020-08-16 20:07:02'),
       ('150', '2020-08-16 20:07:02', '100163', null, '专属客服', '享受专属客服1对1接待', '4', '0', '1', null, null, '0',
        '2020-08-16 20:07:02'),
       ('151', '2020-09-01 20:46:29', '100164', null, '商品折扣', '商品折扣', '1', '0', '1', null, null, '0',
        '2020-09-01 20:46:29'),
       ('152', '2020-09-01 20:46:29', '100164', null, '积分加倍', '购买商品获得的积分加倍', '3', '0', '1', null, null, '0',
        '2020-09-01 20:46:29'),
       ('153', '2020-09-01 20:46:29', '100164', null, '物流优惠', '物流配送方式订单享受包邮免配送费', '2', '0', '1', null, null, '0',
        '2020-09-01 20:46:29'),
       ('154', '2020-09-01 20:46:29', '100164', null, '优先发货', '订单优先发货', '5', '0', '1', null, null, '0',
        '2020-09-01 20:46:29'),
       ('155', '2020-09-01 20:46:29', '100164', null, '急速售后', '申请维权时，系统自动同意维权申请，无需等待人工审核', '6', '0', '1', null, null,
        '0', '2020-09-01 20:46:29'),
       ('156', '2020-09-01 20:46:29', '100164', null, '专属客服', '享受专属客服1对1接待', '4', '0', '1', null, null, '0',
        '2020-09-01 20:46:29'),
       ('157', '2020-09-02 13:17:09', '100165', null, '商品折扣', '商品折扣', '1', '0', '1', null, null, '0',
        '2020-09-02 13:17:09'),
       ('158', '2020-09-02 13:17:09', '100165', null, '积分加倍', '购买商品获得的积分加倍', '3', '0', '1', null, null, '0',
        '2020-09-02 13:17:09'),
       ('159', '2020-09-02 13:17:09', '100165', null, '物流优惠', '物流配送方式订单享受包邮免配送费', '2', '0', '1', null, null, '0',
        '2020-09-02 13:17:09'),
       ('160', '2020-09-02 13:17:09', '100165', null, '优先发货', '订单优先发货', '5', '0', '1', null, null, '0',
        '2020-09-02 13:17:09'),
       ('161', '2020-09-02 13:17:09', '100165', null, '急速售后', '申请维权时，系统自动同意维权申请，无需等待人工审核', '6', '0', '1', null, null,
        '0', '2020-09-02 13:17:09'),
       ('162', '2020-09-02 13:17:09', '100165', null, '专属客服', '享受专属客服1对1接待', '4', '0', '1', null, null, '0',
        '2020-09-02 13:17:09'),
       ('163', '2020-09-02 13:19:07', '100166', null, '商品折扣', '商品折扣', '1', '0', '1', null, null, '0',
        '2020-09-02 13:19:07'),
       ('164', '2020-09-02 13:19:07', '100166', null, '积分加倍', '购买商品获得的积分加倍', '3', '0', '1', null, null, '0',
        '2020-09-02 13:19:07'),
       ('165', '2020-09-02 13:19:07', '100166', null, '物流优惠', '物流配送方式订单享受包邮免配送费', '2', '0', '1', null, null, '0',
        '2020-09-02 13:19:07'),
       ('166', '2020-09-02 13:19:07', '100166', null, '优先发货', '订单优先发货', '5', '0', '1', null, null, '0',
        '2020-09-02 13:19:07'),
       ('167', '2020-09-02 13:19:07', '100166', null, '急速售后', '申请维权时，系统自动同意维权申请，无需等待人工审核', '6', '0', '1', null, null,
        '0', '2020-09-02 13:19:07'),
       ('168', '2020-09-02 13:19:07', '100166', null, '专属客服', '享受专属客服1对1接待', '4', '0', '1', null, null, '0',
        '2020-09-02 13:19:07'),
       ('169', '2020-09-03 09:13:51', '100167', null, '商品折扣', '商品折扣', '1', '0', '1', null, null, '0',
        '2020-09-03 09:13:51'),
       ('170', '2020-09-03 09:13:51', '100167', null, '积分加倍', '购买商品获得的积分加倍', '3', '0', '1', null, null, '0',
        '2020-09-03 09:13:51'),
       ('171', '2020-09-03 09:13:51', '100167', null, '物流优惠', '物流配送方式订单享受包邮免配送费', '2', '0', '1', null, null, '0',
        '2020-09-03 09:13:51'),
       ('172', '2020-09-03 09:13:51', '100167', null, '优先发货', '订单优先发货', '5', '0', '1', null, null, '0',
        '2020-09-03 09:13:51'),
       ('173', '2020-09-03 09:13:51', '100167', null, '急速售后', '申请维权时，系统自动同意维权申请，无需等待人工审核', '6', '0', '1', null, null,
        '0', '2020-09-03 09:13:51'),
       ('174', '2020-09-03 09:13:51', '100167', null, '专属客服', '享受专属客服1对1接待', '4', '0', '1', null, null, '0',
        '2020-09-03 09:13:51'),
       ('175', '2020-09-04 20:45:02', '100168', null, '商品折扣', '商品折扣', '1', '0', '1', null, null, '0',
        '2020-09-04 20:45:02'),
       ('176', '2020-09-04 20:45:02', '100168', null, '积分加倍', '购买商品获得的积分加倍', '3', '0', '1', null, null, '0',
        '2020-09-04 20:45:02');
INSERT INTO `t_member_card_privilege`
VALUES ('177', '2020-09-04 20:45:02', '100168', null, '物流优惠', '物流配送方式订单享受包邮免配送费', '2', '0', '1', null, null, '0',
        '2020-09-04 20:45:02'),
       ('178', '2020-09-04 20:45:02', '100168', null, '优先发货', '订单优先发货', '5', '0', '1', null, null, '0',
        '2020-09-04 20:45:02'),
       ('179', '2020-09-04 20:45:02', '100168', null, '急速售后', '申请维权时，系统自动同意维权申请，无需等待人工审核', '6', '0', '1', null, null,
        '0', '2020-09-04 20:45:02'),
       ('180', '2020-09-04 20:45:02', '100168', null, '专属客服', '享受专属客服1对1接待', '4', '0', '1', null, null, '0',
        '2020-09-04 20:45:02');
COMMIT;

-- ----------------------------
-- Table structure for t_member_card_privilege_goods
-- ----------------------------
DROP TABLE IF EXISTS `t_member_card_privilege_goods`;
CREATE TABLE `t_member_card_privilege_goods`
(
    `id`                bigint                                                       NOT NULL AUTO_INCREMENT,
    `create_time`       datetime                                                     NULL DEFAULT NULL COMMENT '创建时间',
    `tenant_id`         varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '租户id',
    `compute_type`      tinyint(1)                                                   NULL DEFAULT NULL COMMENT '计算方式 0-折扣 1-减价 2-指定价格',
    `goods_id`          bigint                                                       NULL DEFAULT NULL COMMENT '商品id',
    `card_privilege_id` bigint                                                       NULL DEFAULT NULL COMMENT '会员卡权益id',
    `is_deleted`        tinyint(1)                                                   NULL DEFAULT NULL COMMENT '删除状态：0->未删除；1->已删除',
    `update_time`       datetime                                                     NULL DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`)
)
    ENGINE = InnoDB
    DEFAULT CHARACTER SET = utf8mb4
    COLLATE = utf8mb4_0900_ai_ci
    COMMENT ='会员卡商品权益与商品关联表'
    AUTO_INCREMENT = 1
;

-- ----------------------------
-- Records of t_member_card_privilege_goods
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_member_card_privilege_group
-- ----------------------------
DROP TABLE IF EXISTS `t_member_card_privilege_group`;
CREATE TABLE `t_member_card_privilege_group`
(
    `id`             bigint                                                       NOT NULL AUTO_INCREMENT,
    `create_time`    datetime                                                     NULL DEFAULT NULL COMMENT '创建时间',
    `tenant_id`      varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '租户id',
    `privilege_id`   bigint                                                       NOT NULL COMMENT '权益表id',
    `member_card_id` bigint                                                       NOT NULL COMMENT '会员卡id',
    `is_deleted`     tinyint(1)                                                   NULL DEFAULT NULL COMMENT '删除状态：0->未删除；1->已删除',
    `update_time`    datetime                                                     NULL DEFAULT NULL COMMENT '更新时间',
    `value`          decimal(10, 2)                                               NULL DEFAULT NULL COMMENT '计算值',
    PRIMARY KEY (`id`)
)
    ENGINE = InnoDB
    DEFAULT CHARACTER SET = utf8mb4
    COLLATE = utf8mb4_0900_ai_ci
    COMMENT ='会员卡与会员卡权益关联表'
    AUTO_INCREMENT = 1829
;

-- ----------------------------
-- Records of t_member_card_privilege_group
-- ----------------------------
BEGIN;
INSERT INTO `t_member_card_privilege_group`
VALUES ('1640', '2020-08-01 09:41:48', '100002', '1', '1374', '0', '2020-08-01 09:41:48', '50.00'),
       ('1641', '2020-08-01 09:41:48', '100002', '1', '1375', '0', '2020-08-01 09:41:48', '40.00'),
       ('1642', '2020-08-01 09:41:48', '100002', '1', '1376', '0', '2020-08-01 09:41:48', '30.00'),
       ('1643', '2020-08-01 09:41:48', '100002', '1', '1377', '0', '2020-08-01 09:41:48', '20.00'),
       ('1644', '2020-08-01 09:41:48', '100002', '1', '1378', '0', '2020-08-01 09:41:48', '10.00'),
       ('1645', '2020-08-01 09:51:18', '100002', '4', '1379', '0', '2020-08-01 09:51:18', '2.00'),
       ('1646', '2020-08-01 09:51:18', '100002', '1', '1379', '0', '2020-08-01 09:51:18', '50.00'),
       ('1647', '2020-08-01 09:51:18', '100002', '4', '1380', '0', '2020-08-01 09:51:18', '3.00'),
       ('1648', '2020-08-01 09:51:18', '100002', '1', '1380', '0', '2020-08-01 09:51:18', '40.00'),
       ('1649', '2020-08-01 09:51:18', '100002', '4', '1381', '0', '2020-08-01 09:51:18', '4.00'),
       ('1650', '2020-08-01 09:51:18', '100002', '1', '1381', '0', '2020-08-01 09:51:18', '30.00'),
       ('1651', '2020-08-01 09:51:18', '100002', '1', '1382', '0', '2020-08-01 09:51:18', '20.00'),
       ('1652', '2020-08-01 09:51:18', '100002', '1', '1383', '0', '2020-08-01 09:51:18', '10.00'),
       ('1653', '2020-08-01 09:53:37', '100002', '4', '1384', '0', '2020-08-01 09:53:37', '2.00'),
       ('1654', '2020-08-01 09:53:37', '100002', '1', '1384', '0', '2020-08-01 09:53:37', '50.00'),
       ('1655', '2020-08-01 09:53:37', '100002', '4', '1385', '0', '2020-08-01 09:53:37', '3.00'),
       ('1656', '2020-08-01 09:53:37', '100002', '1', '1385', '0', '2020-08-01 09:53:37', '40.00'),
       ('1657', '2020-08-01 09:53:37', '100002', '4', '1386', '0', '2020-08-01 09:53:37', '4.00'),
       ('1658', '2020-08-01 09:53:37', '100002', '1', '1386', '0', '2020-08-01 09:53:37', '30.00'),
       ('1659', '2020-08-01 09:53:37', '100002', '1', '1387', '0', '2020-08-01 09:53:37', '20.00'),
       ('1660', '2020-08-01 09:53:37', '100002', '1', '1388', '0', '2020-08-01 09:53:37', '10.00'),
       ('1661', '2020-08-01 09:56:53', '100002', '4', '1389', '0', '2020-08-01 09:56:53', '2.00'),
       ('1662', '2020-08-01 09:56:53', '100002', '1', '1389', '0', '2020-08-01 09:56:53', '50.00'),
       ('1663', '2020-08-01 09:56:53', '100002', '4', '1390', '0', '2020-08-01 09:56:53', '3.00'),
       ('1664', '2020-08-01 09:56:53', '100002', '1', '1390', '0', '2020-08-01 09:56:53', '40.00'),
       ('1665', '2020-08-01 09:56:53', '100002', '4', '1391', '0', '2020-08-01 09:56:53', '4.00'),
       ('1666', '2020-08-01 09:56:53', '100002', '1', '1391', '0', '2020-08-01 09:56:53', '30.00'),
       ('1667', '2020-08-01 09:56:53', '100002', '1', '1392', '0', '2020-08-01 09:56:53', '20.00'),
       ('1668', '2020-08-01 09:56:53', '100002', '1', '1393', '0', '2020-08-01 09:56:53', '10.00'),
       ('1669', '2020-08-01 11:36:10', '100002', '4', '1394', '0', '2020-08-01 11:36:10', '2.00'),
       ('1670', '2020-08-01 11:36:10', '100002', '1', '1394', '0', '2020-08-01 11:36:10', '50.00'),
       ('1671', '2020-08-01 11:36:10', '100002', '4', '1395', '0', '2020-08-01 11:36:10', '3.00'),
       ('1672', '2020-08-01 11:36:10', '100002', '1', '1395', '0', '2020-08-01 11:36:10', '40.00'),
       ('1673', '2020-08-01 11:36:10', '100002', '4', '1396', '0', '2020-08-01 11:36:10', '4.00'),
       ('1674', '2020-08-01 11:36:10', '100002', '1', '1396', '0', '2020-08-01 11:36:10', '30.00'),
       ('1675', '2020-08-01 11:36:10', '100002', '1', '1397', '0', '2020-08-01 11:36:10', '20.00'),
       ('1676', '2020-08-01 11:36:11', '100002', '1', '1398', '0', '2020-08-01 11:36:11', '10.00'),
       ('1677', '2020-08-01 11:36:15', '100002', '4', '1399', '0', '2020-08-01 11:36:15', '2.00'),
       ('1678', '2020-08-01 11:36:15', '100002', '1', '1399', '0', '2020-08-01 11:36:15', '50.00'),
       ('1679', '2020-08-01 11:36:16', '100002', '4', '1400', '0', '2020-08-01 11:36:16', '3.00'),
       ('1680', '2020-08-01 11:36:16', '100002', '1', '1400', '0', '2020-08-01 11:36:16', '40.00'),
       ('1681', '2020-08-01 11:36:16', '100002', '4', '1401', '0', '2020-08-01 11:36:16', '4.00'),
       ('1682', '2020-08-01 11:36:16', '100002', '1', '1401', '0', '2020-08-01 11:36:16', '30.00'),
       ('1683', '2020-08-01 11:36:16', '100002', '1', '1402', '0', '2020-08-01 11:36:16', '20.00'),
       ('1684', '2020-08-01 11:36:16', '100002', '1', '1403', '0', '2020-08-01 11:36:16', '10.00'),
       ('1685', '2020-08-01 11:39:32', '100002', '4', '1404', '0', '2020-08-01 11:39:32', '2.00'),
       ('1686', '2020-08-01 11:39:32', '100002', '1', '1404', '0', '2020-08-01 11:39:32', '50.00'),
       ('1687', '2020-08-01 11:39:32', '100002', '4', '1405', '0', '2020-08-01 11:39:32', '3.00'),
       ('1688', '2020-08-01 11:39:32', '100002', '1', '1405', '0', '2020-08-01 11:39:32', '40.00'),
       ('1689', '2020-08-01 11:39:32', '100002', '4', '1406', '0', '2020-08-01 11:39:32', '4.00'),
       ('1690', '2020-08-01 11:39:32', '100002', '1', '1406', '0', '2020-08-01 11:39:32', '30.00'),
       ('1691', '2020-08-01 11:39:32', '100002', '1', '1407', '0', '2020-08-01 11:39:32', '20.00'),
       ('1692', '2020-08-01 11:39:32', '100002', '1', '1408', '0', '2020-08-01 11:39:32', '10.00'),
       ('1693', '2020-08-01 12:09:55', '100002', '4', '1409', '0', '2020-08-01 12:09:55', '2.00'),
       ('1694', '2020-08-01 12:09:55', '100002', '1', '1409', '0', '2020-08-01 12:09:55', '50.00'),
       ('1695', '2020-08-01 12:09:55', '100002', '4', '1410', '0', '2020-08-01 12:09:55', '3.00'),
       ('1696', '2020-08-01 12:09:55', '100002', '1', '1410', '0', '2020-08-01 12:09:55', '40.00'),
       ('1697', '2020-08-01 12:09:55', '100002', '4', '1411', '0', '2020-08-01 12:09:55', '4.00'),
       ('1698', '2020-08-01 12:09:55', '100002', '1', '1411', '0', '2020-08-01 12:09:55', '30.00'),
       ('1699', '2020-08-01 12:09:55', '100002', '1', '1412', '0', '2020-08-01 12:09:55', '20.00'),
       ('1700', '2020-08-01 12:09:55', '100002', '1', '1413', '0', '2020-08-01 12:09:55', '10.00'),
       ('1701', '2020-08-01 13:34:43', '100002', '4', '1414', '0', '2020-08-01 13:34:43', '2.00'),
       ('1702', '2020-08-01 13:34:43', '100002', '1', '1414', '0', '2020-08-01 13:34:43', '50.00'),
       ('1703', '2020-08-01 13:34:43', '100002', '4', '1415', '0', '2020-08-01 13:34:43', '3.00'),
       ('1704', '2020-08-01 13:34:43', '100002', '1', '1415', '0', '2020-08-01 13:34:43', '40.00'),
       ('1705', '2020-08-01 13:34:43', '100002', '4', '1416', '0', '2020-08-01 13:34:43', '4.00'),
       ('1706', '2020-08-01 13:34:43', '100002', '1', '1416', '0', '2020-08-01 13:34:43', '30.00'),
       ('1707', '2020-08-01 13:34:43', '100002', '1', '1417', '0', '2020-08-01 13:34:43', '20.00'),
       ('1708', '2020-08-01 13:34:43', '100002', '1', '1418', '0', '2020-08-01 13:34:43', '10.00'),
       ('1709', '2020-08-01 14:38:25', '100002', '4', '1419', '0', '2020-08-01 14:38:25', '2.00'),
       ('1710', '2020-08-01 14:38:25', '100002', '1', '1419', '0', '2020-08-01 14:38:25', '50.00'),
       ('1711', '2020-08-01 14:38:25', '100002', '4', '1420', '0', '2020-08-01 14:38:25', '3.00'),
       ('1712', '2020-08-01 14:38:25', '100002', '1', '1420', '0', '2020-08-01 14:38:25', '40.00'),
       ('1713', '2020-08-01 14:38:25', '100002', '4', '1421', '0', '2020-08-01 14:38:25', '4.00'),
       ('1714', '2020-08-01 14:38:25', '100002', '1', '1421', '0', '2020-08-01 14:38:25', '30.00'),
       ('1715', '2020-08-01 14:38:25', '100002', '1', '1422', '0', '2020-08-01 14:38:25', '20.00'),
       ('1716', '2020-08-01 14:38:25', '100002', '1', '1423', '0', '2020-08-01 14:38:25', '10.00'),
       ('1717', '2020-08-03 11:20:12', '100002', '4', '1424', '0', '2020-08-03 11:20:12', '2.00'),
       ('1718', '2020-08-03 11:20:12', '100002', '1', '1424', '0', '2020-08-03 11:20:12', '50.00'),
       ('1719', '2020-08-03 11:20:12', '100002', '4', '1425', '0', '2020-08-03 11:20:12', '3.00'),
       ('1720', '2020-08-03 11:20:12', '100002', '1', '1425', '0', '2020-08-03 11:20:12', '40.00'),
       ('1721', '2020-08-03 11:20:12', '100002', '4', '1426', '0', '2020-08-03 11:20:12', '4.00'),
       ('1722', '2020-08-03 11:20:12', '100002', '1', '1426', '0', '2020-08-03 11:20:12', '30.00'),
       ('1723', '2020-08-03 11:20:12', '100002', '1', '1427', '0', '2020-08-03 11:20:12', '20.00'),
       ('1724', '2020-08-03 11:20:12', '100002', '1', '1428', '0', '2020-08-03 11:20:12', '10.00'),
       ('1725', '2020-08-03 23:58:39', '100002', '4', '1434', '0', '2020-08-03 23:58:39', '2.00'),
       ('1726', '2020-08-03 23:58:39', '100002', '1', '1434', '0', '2020-08-03 23:58:39', '50.00'),
       ('1727', '2020-08-03 23:58:39', '100002', '4', '1435', '0', '2020-08-03 23:58:39', '3.00'),
       ('1728', '2020-08-03 23:58:39', '100002', '1', '1435', '0', '2020-08-03 23:58:39', '40.00'),
       ('1729', '2020-08-03 23:58:39', '100002', '4', '1436', '0', '2020-08-03 23:58:39', '4.00'),
       ('1730', '2020-08-03 23:58:39', '100002', '1', '1436', '0', '2020-08-03 23:58:39', '30.00'),
       ('1731', '2020-08-03 23:58:39', '100002', '1', '1437', '0', '2020-08-03 23:58:39', '20.00'),
       ('1732', '2020-08-03 23:58:39', '100002', '1', '1438', '0', '2020-08-03 23:58:39', '10.00'),
       ('1733', '2020-08-04 20:22:02', '100002', '4', '1454', '0', '2020-08-04 20:22:02', '2.00'),
       ('1734', '2020-08-04 20:22:02', '100002', '1', '1454', '0', '2020-08-04 20:22:02', '50.00'),
       ('1735', '2020-08-04 20:22:02', '100002', '4', '1455', '0', '2020-08-04 20:22:02', '3.00'),
       ('1736', '2020-08-04 20:22:02', '100002', '1', '1455', '0', '2020-08-04 20:22:02', '40.00'),
       ('1737', '2020-08-04 20:22:02', '100002', '4', '1456', '0', '2020-08-04 20:22:02', '4.00'),
       ('1738', '2020-08-04 20:22:02', '100002', '1', '1456', '0', '2020-08-04 20:22:02', '30.00'),
       ('1739', '2020-08-04 20:22:02', '100002', '1', '1457', '0', '2020-08-04 20:22:02', '20.00');
INSERT INTO `t_member_card_privilege_group`
VALUES ('1740', '2020-08-04 20:22:02', '100002', '1', '1458', '0', '2020-08-04 20:22:02', '10.00'),
       ('1741', '2020-08-04 20:42:14', '100002', '4', '1459', '0', '2020-08-04 20:42:14', '2.00'),
       ('1742', '2020-08-04 20:42:14', '100002', '1', '1459', '0', '2020-08-04 20:42:14', '50.00'),
       ('1743', '2020-08-04 20:42:14', '100002', '4', '1460', '0', '2020-08-04 20:42:14', '3.00'),
       ('1744', '2020-08-04 20:42:14', '100002', '1', '1460', '0', '2020-08-04 20:42:14', '40.00'),
       ('1745', '2020-08-04 20:42:14', '100002', '4', '1461', '0', '2020-08-04 20:42:14', '4.00'),
       ('1746', '2020-08-04 20:42:14', '100002', '1', '1461', '0', '2020-08-04 20:42:14', '30.00'),
       ('1747', '2020-08-04 20:42:14', '100002', '1', '1462', '0', '2020-08-04 20:42:14', '20.00'),
       ('1748', '2020-08-04 20:42:14', '100002', '1', '1463', '0', '2020-08-04 20:42:14', '10.00'),
       ('1749', '2020-08-04 20:46:37', '100002', '4', '1464', '0', '2020-08-04 20:46:37', '2.00'),
       ('1750', '2020-08-04 20:46:37', '100002', '1', '1464', '0', '2020-08-04 20:46:37', '50.00'),
       ('1751', '2020-08-04 20:46:37', '100002', '4', '1465', '0', '2020-08-04 20:46:37', '3.00'),
       ('1752', '2020-08-04 20:46:38', '100002', '1', '1465', '0', '2020-08-04 20:46:38', '40.00'),
       ('1753', '2020-08-04 20:46:38', '100002', '4', '1466', '0', '2020-08-04 20:46:38', '4.00'),
       ('1754', '2020-08-04 20:46:38', '100002', '1', '1466', '0', '2020-08-04 20:46:38', '30.00'),
       ('1755', '2020-08-04 20:46:38', '100002', '1', '1467', '0', '2020-08-04 20:46:38', '20.00'),
       ('1756', '2020-08-04 20:46:38', '100002', '1', '1468', '0', '2020-08-04 20:46:38', '10.00'),
       ('1757', '2020-08-04 21:02:52', '100002', '4', '1469', '0', '2020-08-04 21:02:52', '2.00'),
       ('1758', '2020-08-04 21:02:52', '100002', '1', '1469', '0', '2020-08-04 21:02:52', '50.00'),
       ('1759', '2020-08-04 21:02:52', '100002', '4', '1470', '0', '2020-08-04 21:02:52', '3.00'),
       ('1760', '2020-08-04 21:02:52', '100002', '1', '1470', '0', '2020-08-04 21:02:52', '40.00'),
       ('1761', '2020-08-04 21:02:52', '100002', '4', '1471', '0', '2020-08-04 21:02:52', '4.00'),
       ('1762', '2020-08-04 21:02:52', '100002', '1', '1471', '0', '2020-08-04 21:02:52', '30.00'),
       ('1763', '2020-08-04 21:02:52', '100002', '1', '1472', '0', '2020-08-04 21:02:52', '20.00'),
       ('1764', '2020-08-04 21:02:52', '100002', '1', '1473', '0', '2020-08-04 21:02:52', '10.00'),
       ('1765', '2020-08-04 21:55:42', '100002', '4', '1474', '0', '2020-08-04 21:55:42', '2.00'),
       ('1766', '2020-08-04 21:55:42', '100002', '1', '1474', '0', '2020-08-04 21:55:42', '50.00'),
       ('1767', '2020-08-04 21:55:42', '100002', '4', '1475', '0', '2020-08-04 21:55:42', '3.00'),
       ('1768', '2020-08-04 21:55:42', '100002', '1', '1475', '0', '2020-08-04 21:55:42', '40.00'),
       ('1769', '2020-08-04 21:55:42', '100002', '4', '1476', '0', '2020-08-04 21:55:42', '4.00'),
       ('1770', '2020-08-04 21:55:42', '100002', '1', '1476', '0', '2020-08-04 21:55:42', '30.00'),
       ('1771', '2020-08-04 21:55:42', '100002', '1', '1477', '0', '2020-08-04 21:55:42', '20.00'),
       ('1772', '2020-08-04 21:55:42', '100002', '1', '1478', '0', '2020-08-04 21:55:42', '10.00'),
       ('1773', '2020-08-05 08:46:09', '100002', '4', '1479', '0', '2020-08-05 08:46:09', '2.00'),
       ('1774', '2020-08-05 08:46:09', '100002', '1', '1479', '0', '2020-08-05 08:46:09', '50.00'),
       ('1775', '2020-08-05 08:46:09', '100002', '4', '1480', '0', '2020-08-05 08:46:09', '3.00'),
       ('1776', '2020-08-05 08:46:09', '100002', '1', '1480', '0', '2020-08-05 08:46:09', '40.00'),
       ('1777', '2020-08-05 08:46:09', '100002', '4', '1481', '0', '2020-08-05 08:46:09', '4.00'),
       ('1778', '2020-08-05 08:46:09', '100002', '1', '1481', '0', '2020-08-05 08:46:09', '30.00'),
       ('1779', '2020-08-05 08:46:09', '100002', '1', '1482', '0', '2020-08-05 08:46:09', '20.00'),
       ('1780', '2020-08-05 08:46:09', '100002', '1', '1483', '0', '2020-08-05 08:46:09', '10.00'),
       ('1781', '2020-08-07 22:07:16', '100002', '4', '1489', '0', '2020-08-07 22:07:16', '2.00'),
       ('1782', '2020-08-07 22:07:17', '100002', '1', '1489', '0', '2020-08-07 22:07:17', '50.00'),
       ('1783', '2020-08-07 22:07:17', '100002', '4', '1490', '0', '2020-08-07 22:07:17', '3.00'),
       ('1784', '2020-08-07 22:07:17', '100002', '1', '1490', '0', '2020-08-07 22:07:17', '40.00'),
       ('1785', '2020-08-07 22:07:17', '100002', '4', '1491', '0', '2020-08-07 22:07:17', '4.00'),
       ('1786', '2020-08-07 22:07:17', '100002', '1', '1491', '0', '2020-08-07 22:07:17', '30.00'),
       ('1787', '2020-08-07 22:07:17', '100002', '1', '1492', '0', '2020-08-07 22:07:17', '20.00'),
       ('1788', '2020-08-07 22:07:17', '100002', '1', '1493', '0', '2020-08-07 22:07:17', '10.00'),
       ('1789', '2020-08-12 10:57:22', '100002', '4', '1504', '0', '2020-08-12 10:57:22', '2.00'),
       ('1790', '2020-08-12 10:57:22', '100002', '1', '1504', '0', '2020-08-12 10:57:22', '50.00'),
       ('1791', '2020-08-12 10:57:22', '100002', '4', '1505', '0', '2020-08-12 10:57:22', '3.00'),
       ('1792', '2020-08-12 10:57:22', '100002', '1', '1505', '0', '2020-08-12 10:57:22', '40.00'),
       ('1793', '2020-08-12 10:57:22', '100002', '4', '1506', '0', '2020-08-12 10:57:22', '4.00'),
       ('1794', '2020-08-12 10:57:22', '100002', '1', '1506', '0', '2020-08-12 10:57:22', '30.00'),
       ('1795', '2020-08-12 10:57:22', '100002', '1', '1507', '0', '2020-08-12 10:57:22', '20.00'),
       ('1796', '2020-08-12 10:57:22', '100002', '1', '1508', '0', '2020-08-12 10:57:22', '10.00'),
       ('1797', '2020-08-12 11:03:53', '100002', '4', '1509', '0', '2020-08-12 11:03:53', '2.00'),
       ('1798', '2020-08-12 11:03:53', '100002', '1', '1509', '0', '2020-08-12 11:03:53', '50.00'),
       ('1799', '2020-08-12 11:03:53', '100002', '4', '1510', '0', '2020-08-12 11:03:53', '3.00'),
       ('1800', '2020-08-12 11:03:53', '100002', '1', '1510', '0', '2020-08-12 11:03:53', '40.00'),
       ('1801', '2020-08-12 11:03:53', '100002', '4', '1511', '0', '2020-08-12 11:03:53', '4.00'),
       ('1802', '2020-08-12 11:03:53', '100002', '1', '1511', '0', '2020-08-12 11:03:53', '30.00'),
       ('1803', '2020-08-12 11:03:53', '100002', '1', '1512', '0', '2020-08-12 11:03:53', '20.00'),
       ('1804', '2020-08-12 11:03:53', '100002', '1', '1513', '0', '2020-08-12 11:03:53', '10.00'),
       ('1805', '2020-08-12 15:00:57', '100002', '4', '1514', '0', '2020-08-12 15:00:57', '2.00'),
       ('1806', '2020-08-12 15:00:57', '100002', '1', '1514', '0', '2020-08-12 15:00:57', '50.00'),
       ('1807', '2020-08-12 15:00:57', '100002', '4', '1515', '0', '2020-08-12 15:00:57', '3.00'),
       ('1808', '2020-08-12 15:00:57', '100002', '1', '1515', '0', '2020-08-12 15:00:57', '40.00'),
       ('1809', '2020-08-12 15:00:57', '100002', '4', '1516', '0', '2020-08-12 15:00:57', '4.00'),
       ('1810', '2020-08-12 15:00:57', '100002', '1', '1516', '0', '2020-08-12 15:00:57', '30.00'),
       ('1811', '2020-08-12 15:00:57', '100002', '1', '1517', '0', '2020-08-12 15:00:57', '20.00'),
       ('1812', '2020-08-12 15:00:57', '100002', '1', '1518', '0', '2020-08-12 15:00:57', '10.00'),
       ('1813', '2020-08-17 13:13:56', '100002', '4', '1554', '0', '2020-08-17 13:13:56', '2.00'),
       ('1814', '2020-08-17 13:13:56', '100002', '1', '1554', '0', '2020-08-17 13:13:56', '50.00'),
       ('1815', '2020-08-17 13:13:56', '100002', '4', '1555', '0', '2020-08-17 13:13:56', '3.00'),
       ('1816', '2020-08-17 13:13:56', '100002', '1', '1555', '0', '2020-08-17 13:13:56', '40.00'),
       ('1817', '2020-08-17 13:13:56', '100002', '4', '1556', '0', '2020-08-17 13:13:56', '4.00'),
       ('1818', '2020-08-17 13:13:56', '100002', '1', '1556', '0', '2020-08-17 13:13:56', '30.00'),
       ('1819', '2020-08-17 13:13:56', '100002', '1', '1557', '0', '2020-08-17 13:13:56', '20.00'),
       ('1820', '2020-08-17 13:13:56', '100002', '1', '1558', '0', '2020-08-17 13:13:56', '10.00'),
       ('1821', '2020-08-17 13:15:13', '100002', '4', '1559', '0', '2020-08-17 13:15:13', '2.00'),
       ('1822', '2020-08-17 13:15:13', '100002', '1', '1559', '0', '2020-08-17 13:15:13', '50.00'),
       ('1823', '2020-08-17 13:15:13', '100002', '4', '1560', '0', '2020-08-17 13:15:13', '3.00'),
       ('1824', '2020-08-17 13:15:13', '100002', '1', '1560', '0', '2020-08-17 13:15:13', '40.00'),
       ('1825', '2020-08-17 13:15:13', '100002', '4', '1561', '0', '2020-08-17 13:15:13', '4.00'),
       ('1826', '2020-08-17 13:15:13', '100002', '1', '1561', '0', '2020-08-17 13:15:13', '30.00'),
       ('1827', '2020-08-17 13:15:13', '100002', '1', '1562', '0', '2020-08-17 13:15:13', '20.00'),
       ('1828', '2020-08-17 13:15:13', '100002', '1', '1563', '0', '2020-08-17 13:15:13', '10.00');
COMMIT;

-- ----------------------------
-- Table structure for t_member_card_privilege_rule
-- ----------------------------
DROP TABLE IF EXISTS `t_member_card_privilege_rule`;
CREATE TABLE `t_member_card_privilege_rule`
(
    `id`                bigint                                                       NOT NULL AUTO_INCREMENT,
    `tenant_id`         varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '租户id',
    `privilege_type`    tinyint(1)                                                   NULL DEFAULT NULL COMMENT '特权计算类型 0-无需计算 1-折扣计算 2-倍数计算 3-指定价格计算 4-免除邮费计算',
    `value`             decimal(10, 2)                                               NULL DEFAULT NULL COMMENT '计算值',
    `card_privilege_id` bigint                                                       NULL DEFAULT NULL COMMENT '权益id',
    `create_time`       datetime                                                     NULL DEFAULT NULL COMMENT '创建时间',
    `is_deleted`        tinyint(1)                                                   NULL DEFAULT NULL COMMENT '删除状态：0->未删除；1->已删除',
    `update_time`       datetime                                                     NULL DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`)
)
    ENGINE = InnoDB
    DEFAULT CHARACTER SET = utf8mb4
    COLLATE = utf8mb4_0900_ai_ci
    COMMENT ='会员卡权益规则表'
    AUTO_INCREMENT = 1
;

-- ----------------------------
-- Records of t_member_card_privilege_rule
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_member_info
-- ----------------------------
DROP TABLE IF EXISTS `t_member_info`;
CREATE TABLE `t_member_info`
(
    `id`                   bigint                                                         NOT NULL AUTO_INCREMENT COMMENT '会员id ',
    `member_number`        varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci   NULL DEFAULT NULL COMMENT '会员卡编号',
    `member_qrcode`        varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL DEFAULT NULL COMMENT '会员卡二维码url',
    `supply_bonus`         decimal(10, 2)                                                 NULL DEFAULT 0.00 COMMENT '会员卡余额',
    `state`                tinyint                                                        NULL DEFAULT 0 COMMENT '会员卡注册状态 0未注册,1已注册  2-会员到期',
    `member_card_info_id`  bigint                                                         NULL DEFAULT NULL COMMENT '会员卡Id',
    `member_register_time` datetime                                                       NULL DEFAULT NULL COMMENT '会员注册时间',
    `member_expire_time`   datetime                                                       NULL DEFAULT NULL,
    `member_register_type` tinyint                                                        NULL DEFAULT NULL COMMENT '会员注册方式 0订单购买,1-积分兑换,2-后台设置',
    `create_time`          datetime                                                       NULL DEFAULT NULL COMMENT '创建时间',
    `is_deleted`           tinyint                                                        NULL DEFAULT NULL COMMENT '删除状态：0->未删除；1->已删除',
    `update_time`          datetime                                                       NULL DEFAULT NULL COMMENT '更新时间',
    `user_id`              varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci   NULL DEFAULT NULL COMMENT '用户id',
    `tenant_id`            varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci   NULL DEFAULT NULL COMMENT '租户id',
    `register_data`        varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '注册表单信息',
    PRIMARY KEY (`id`),
    INDEX `user_id` (`user_id`) USING BTREE,
    INDEX `tenant_id` (`tenant_id`) USING BTREE,
    INDEX `member_number` (`member_number`) USING BTREE
)
    ENGINE = InnoDB
    DEFAULT CHARACTER SET = utf8mb4
    COLLATE = utf8mb4_0900_ai_ci
    COMMENT ='会员信息表'
    AUTO_INCREMENT = 217
;

-- ----------------------------
-- Records of t_member_info
-- ----------------------------
BEGIN;
INSERT INTO `t_member_info`
VALUES ('197', '1000022008013420103', null, '0.00', '1', '1423', '2020-08-01 09:46:24', '2021-08-01 09:46:24', '1',
        '2020-08-01 09:46:24', '0', '2020-08-01 09:46:24', '1248795148536647680', '100002', null),
       ('198', '1000022008013420104', null, '0.00', '1', '1375', '2020-08-01 09:46:24', '2021-08-01 09:46:24', '4',
        '2020-08-01 09:46:24', '0', '2020-08-01 09:46:24', '1248795148536647680', '100002', null),
       ('199', '1000022008015406163', null, '0.00', '1', '1410', '2020-08-01 10:37:59', '2021-08-02 10:37:59', '4',
        '2020-08-01 10:37:59', '0', '2020-08-01 10:37:59', '1246647917666766848', '100002', null),
       ('200', '1000022008016553663', 'https://oss-tencent.bgniao.cn/api/platinum_card.png', '0.00', '1', '1389',
        '2020-08-01 11:01:00', '2021-08-01 11:01:00', '2', '2020-08-01 11:01:00', '0', '2020-08-01 11:01:00',
        '1277614194182721536', '100002', null),
       ('201', '1000022008013032446', null, '0.00', '1', '1481', '2020-08-01 13:34:59', '2021-11-09 13:34:59', '0',
        '2020-08-01 13:34:59', '0', '2020-08-01 13:34:59', '1246698215999410176', '100002', ''),
       ('202', '1000022008010262334', null, '0.00', '1', '1421', '2020-08-01 14:34:08', '2021-08-03 14:34:08', '0',
        '2020-08-01 14:34:08', '0', '2020-08-01 14:34:08', '1247686809614422016', '100002', ''),
       ('203', '1000022008016005123', null, '0.00', '1', '1419', '2020-08-01 14:45:43', '2021-08-02 14:45:43', '0',
        '2020-08-01 14:45:43', '0', '2020-08-01 14:45:43', '1247329015887433728', '100002', '1'),
       ('204', '1000022008030142004', 'https://oss-tencent.bgniao.cn/api/platinum_card.png', '0.00', '1', '1419',
        '2020-08-03 10:53:04', '2021-08-03 10:53:04', '2', '2020-08-03 10:53:04', '0', '2020-08-03 10:53:04',
        '1260488910790856704', '100002', null),
       ('205', '1001582008046055264', null, '0.00', '1', '1450', '2020-08-04 14:10:17', '2021-08-04 14:10:17', '1',
        '2020-08-04 14:10:17', '0', '2020-08-04 14:10:17', '1290528033970720768', '100158', null),
       ('206', '1000022008042256124', null, '0.00', '1', '1454', '2020-08-04 20:31:21', '2021-08-04 20:31:21', '3',
        '2020-08-04 20:31:21', '1', '2020-08-04 20:31:21', '1246366999534243840', '100002', null),
       ('207', '1000022008041065246', null, '0.00', '1', '1464', '2020-08-04 20:47:27', '2022-08-04 20:47:27', '3',
        '2020-08-04 20:47:27', '1', '2020-08-04 20:47:27', '1246366999534243840', '100002', null),
       ('208', '1000022008041165552', null, '0.00', '1', '1474', '2020-08-04 22:02:35', '2023-08-16 22:02:35', '3',
        '2020-08-04 22:02:35', '0', '2020-08-04 22:02:35', '1246366999534243840', '100002', null),
       ('209', '1000022008076343505', null, '0.00', '1', '1483', '2020-08-07 14:21:05', '2021-08-07 14:21:05', '3',
        '2020-08-07 14:21:05', '0', '2020-08-07 14:21:05', '1260737223138086912', '100002', null),
       ('210', '1000022008112340355', null, '0.00', '1', '1489', '2020-08-11 22:04:31', '2021-08-11 22:04:31', '0',
        '2020-08-11 22:04:31', '0', '2020-08-11 22:04:31', '1247686809614422016', '100002', ''),
       ('211', '1000022008110265356', null, '0.00', '1', '1490', '2020-08-11 22:23:13', '2021-08-11 22:23:13', '0',
        '2020-08-11 22:23:13', '0', '2020-08-11 22:23:13', '1247686809614422016', '100002', ''),
       ('212', '1000022008125411456', null, '0.00', '1', '1504', '2020-08-12 10:57:32', '2021-08-12 10:57:32', '1',
        '2020-08-12 10:57:32', '0', '2020-08-12 10:57:32', '1247327193193910272', '100002', ''),
       ('213', '1000022008126126506', null, '0.00', '1', '1505', '2020-08-12 10:58:05', '2021-08-12 10:58:05', '1',
        '2020-08-12 10:58:05', '0', '2020-08-12 10:58:05', '1247327193193910272', '100002', ''),
       ('214', '1000022008122055211', null, '0.00', '1', '1507', '2020-08-12 11:01:20', '2021-08-12 11:01:20', '1',
        '2020-08-12 11:01:20', '0', '2020-08-12 11:01:20', '1247327193193910272', '100002', ''),
       ('215', '1000022008126323045', null, '0.00', '1', '1506', '2020-08-12 11:03:57', '2021-08-12 11:03:57', '1',
        '2020-08-12 11:03:57', '0', '2020-08-12 11:03:57', '1247327193193910272', '100002', ''),
       ('216', '1000022008120364245', null, '0.00', '2', '1509', '2020-08-12 11:05:19', '2020-08-13 11:05:19', '1',
        '2020-08-12 11:05:19', '0', '2020-09-05 01:00:00', '1247327193193910272', '100002', '');
COMMIT;

-- ----------------------------
-- Table structure for t_member_order_info
-- ----------------------------
DROP TABLE IF EXISTS `t_member_order_info`;
CREATE TABLE `t_member_order_info`
(
    `id`             bigint                                                         NOT NULL AUTO_INCREMENT,
    `create_time`    datetime                                                       NULL     DEFAULT NULL COMMENT '创建时间',
    `update_time`    datetime                                                       NULL     DEFAULT NULL COMMENT '更新时间',
    `is_deleted`     tinyint UNSIGNED                                               NOT NULL DEFAULT 0 COMMENT '删除状态：0->未删除；1->已删除',
    `order_id`       bigint                                                         NULL     DEFAULT 0 COMMENT '订单id',
    `user_id`        varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci   NULL     DEFAULT NULL COMMENT '用户id',
    `member_card_id` bigint                                                         NULL     DEFAULT 0 COMMENT '会员卡id',
    `pay_amount`     decimal(10, 2)                                                 NULL     DEFAULT 0.00 COMMENT '充值金额',
    `pay_time`       datetime                                                       NULL     DEFAULT NULL COMMENT '付款时间',
    `tenant_id`      varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci   NULL     DEFAULT NULL COMMENT '租户id',
    `usable_amount`  decimal(10, 2)                                                 NULL     DEFAULT 0.00 COMMENT '可用余额（表示充值之后当时可用余额）',
    `note`           varchar(1280) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL     DEFAULT NULL COMMENT '备注',
    `state`          tinyint                                                        NULL     DEFAULT 0 COMMENT '0:不覆盖；1：覆盖',
    PRIMARY KEY (`id`)
)
    ENGINE = InnoDB
    DEFAULT CHARACTER SET = utf8
    COLLATE = utf8_general_ci
    COMMENT ='会员储值订单信息'
    AUTO_INCREMENT = 2204928
;

-- ----------------------------
-- Records of t_member_order_info
-- ----------------------------
BEGIN;
INSERT INTO `t_member_order_info`
VALUES ('2204924', '2020-08-01 10:43:26', '2020-08-01 22:22:56', '0', '1000022008011311013', '1246647917666766848',
        '1390', '1000.01', '2020-08-01 10:43:26', '100002', '10483.47', '', '1'),
       ('2204925', '2020-08-01 13:36:05', '2020-08-01 22:05:16', '0', '1000022008011232031', '1246698215999410176',
        '1414', '1000.01', '2020-08-01 13:36:05', '100002', '1000.01', 'weq', '0'),
       ('2204926', '2020-08-17 08:41:04', '2020-08-17 08:41:04', '0', '1000022008175214204', '1247327193193910272',
        '1507', '1000.01', '2020-08-17 08:41:04', '100002', '1001.51', null, '0'),
       ('2204927', '2020-08-17 14:53:06', '2020-08-17 14:53:06', '0', '1000022008172626212', '1247329015887433728',
        '1419', '1000.01', '2020-08-17 14:53:06', '100002', '1212.88', null, '0');
COMMIT;

-- ----------------------------
-- Table structure for t_member_pay_rule
-- ----------------------------
DROP TABLE IF EXISTS `t_member_pay_rule`;
CREATE TABLE `t_member_pay_rule`
(
    `id`              bigint                                                       NOT NULL AUTO_INCREMENT,
    `create_time`     datetime                                                     NULL     DEFAULT NULL COMMENT '创建时间',
    `update_time`     datetime                                                     NULL     DEFAULT NULL COMMENT '更新时间',
    `is_deleted`      tinyint UNSIGNED                                             NOT NULL DEFAULT 0 COMMENT '删除状态：0->未删除；1->已删除',
    `state`           tinyint                                                      NULL     DEFAULT 0 COMMENT '会员卡注册状态 0无优惠,1有优惠',
    `discount_amount` decimal(10, 2)                                               NULL     DEFAULT 0.00 COMMENT '优惠金额',
    `pay_amount`      decimal(10, 2)                                               NULL     DEFAULT 0.00 COMMENT '充值金额',
    `tenant_id`       varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL     DEFAULT NULL COMMENT '租户id',
    PRIMARY KEY (`id`)
)
    ENGINE = InnoDB
    DEFAULT CHARACTER SET = utf8
    COLLATE = utf8_general_ci
    COMMENT ='会员储值规则信息'
    AUTO_INCREMENT = 148
;

-- ----------------------------
-- Records of t_member_pay_rule
-- ----------------------------
BEGIN;
INSERT INTO `t_member_pay_rule`
VALUES ('144', '2020-08-01 09:19:18', '2020-08-01 09:19:18', '1', '1', '1000.00', '0.01', '100002'),
       ('145', '2020-08-01 09:19:18', '2020-08-01 09:19:18', '1', '1', '10.00', '1.00', '100002'),
       ('146', '2020-08-30 20:51:46', '2020-08-30 20:51:46', '0', '1', '1000.00', '0.01', '100002'),
       ('147', '2020-08-30 20:51:46', '2020-08-30 20:51:46', '0', '1', '10.00', '1.00', '100002');
COMMIT;

-- ----------------------------
-- Table structure for t_member_rebate_settings
-- ----------------------------
DROP TABLE IF EXISTS `t_member_rebate_settings`;
CREATE TABLE `t_member_rebate_settings`
(
    `id`                bigint                                                       NOT NULL AUTO_INCREMENT,
    `create_time`       datetime                                                     NULL     DEFAULT NULL COMMENT '创建时间',
    `update_time`       datetime                                                     NULL     DEFAULT NULL COMMENT '更新时间',
    `is_deleted`        tinyint UNSIGNED                                             NOT NULL DEFAULT 0 COMMENT '删除状态：0->未删除；1->已删除',
    `rebate_condition`  varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL     DEFAULT NULL COMMENT '	返利条件，格式：\"普通用户/会员\"，0表示未勾选，1表示勾选',
    `balance_condition` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL     DEFAULT NULL COMMENT '余额使用条件，格式：\"普通用户/会员\"，0表示未勾选，1表示勾选',
    `rebate_settings`   tinyint                                                      NULL     DEFAULT 0 COMMENT '返利设置，0代表不使用、1代表固定金额、2代表百分比',
    `rebate_amount`     decimal(10, 2)                                               NULL     DEFAULT 0.00 COMMENT '固定金额或者百分比数量（%）',
    `tenant_id`         varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL     DEFAULT NULL COMMENT '租户id',
    PRIMARY KEY (`id`)
)
    ENGINE = InnoDB
    DEFAULT CHARACTER SET = utf8
    COLLATE = utf8_general_ci
    COMMENT ='会员返利设置'
    AUTO_INCREMENT = 1
;

-- ----------------------------
-- Records of t_member_rebate_settings
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_member_register_form
-- ----------------------------
DROP TABLE IF EXISTS `t_member_register_form`;
CREATE TABLE `t_member_register_form`
(
    `id`           bigint                                                       NOT NULL AUTO_INCREMENT,
    `create_time`  datetime                                                     NULL     DEFAULT NULL COMMENT '创建时间',
    `update_time`  datetime                                                     NULL     DEFAULT NULL COMMENT '更新时间',
    `is_deleted`   tinyint UNSIGNED                                             NOT NULL DEFAULT 0 COMMENT '删除状态：0->未删除；1->已删除',
    `tenant_id`    varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL     DEFAULT NULL COMMENT '租户id',
    `form_id`      varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci  NULL     DEFAULT NULL COMMENT '表单id',
    `form_name`    varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL     DEFAULT NULL COMMENT '表单名称',
    `form_pattern` tinyint UNSIGNED                                             NULL     DEFAULT 1 COMMENT '表单格式，1表示身份证，2表示文本',
    `is_required`  tinyint UNSIGNED                                             NULL     DEFAULT 1 COMMENT '是否必填，1表示必填，2表示非必填',
    `tips`         varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL     DEFAULT NULL COMMENT '提示语',
    PRIMARY KEY (`id`)
)
    ENGINE = InnoDB
    DEFAULT CHARACTER SET = utf8
    COLLATE = utf8_general_ci
    COMMENT ='会员注册表单表'
    AUTO_INCREMENT = 40
;

-- ----------------------------
-- Records of t_member_register_form
-- ----------------------------
BEGIN;
INSERT INTO `t_member_register_form`
VALUES ('23', '2020-08-01 09:41:48', '2020-08-17 13:15:13', '0', '100002', '1', '手机号', '3', '1', '请输入手机号'),
       ('24', '2020-08-01 09:41:48', '2020-08-17 13:15:13', '0', '100002', '2', '身份证', '1', '2', '请输入身份证号'),
       ('25', '2020-08-04 13:43:10', '2020-08-04 14:09:07', '0', '100158', '1', '手机号', '3', '1', '请输入手机号'),
       ('26', '2020-08-08 11:16:38', '2020-08-08 11:16:38', '0', '100160', '1', '手机号', '3', '1', '请输入手机号'),
       ('27', '2020-08-11 21:37:09', '2020-08-11 21:37:09', '0', '100161', '1', '手机号', '3', '1', '请输入手机号'),
       ('28', '2020-08-16 10:05:26', '2020-08-16 10:05:26', '0', '100162', '1', '手机号', '3', '1', '请输入手机号'),
       ('29', '2020-08-16 10:05:56', '2020-08-16 10:05:56', '0', '100162', '1', '手机号', '3', '1', '请输入手机号'),
       ('30', '2020-08-16 10:43:43', '2020-08-16 10:43:43', '0', '100162', '1', '手机号', '3', '1', '请输入手机号'),
       ('31', '2020-08-16 10:44:29', '2020-08-16 10:44:29', '0', '100162', '1', '手机号', '3', '1', '请输入手机号'),
       ('32', '2020-08-16 10:44:42', '2020-08-16 10:44:42', '0', '100162', '1', '手机号', '3', '1', '请输入手机号'),
       ('33', '2020-08-16 10:51:13', '2020-08-16 10:51:13', '0', '100162', '1', '手机号', '3', '1', '请输入手机号'),
       ('34', '2020-08-16 20:07:02', '2020-08-16 20:07:02', '0', '100163', '1', '手机号', '3', '1', '请输入手机号'),
       ('35', '2020-09-01 20:46:30', '2020-09-01 20:46:30', '0', '100164', '1', '手机号', '3', '1', '请输入手机号'),
       ('36', '2020-09-02 13:17:09', '2020-09-02 13:17:09', '0', '100165', '1', '手机号', '3', '1', '请输入手机号'),
       ('37', '2020-09-02 13:19:07', '2020-09-02 13:19:07', '0', '100166', '1', '手机号', '3', '1', '请输入手机号'),
       ('38', '2020-09-03 09:13:51', '2020-09-03 09:13:51', '0', '100167', '1', '手机号', '3', '1', '请输入手机号'),
       ('39', '2020-09-04 20:45:03', '2020-09-04 20:45:03', '0', '100168', '1', '手机号', '3', '1', '请输入手机号');
COMMIT;

-- ----------------------------
-- Table structure for t_member_switch
-- ----------------------------
DROP TABLE IF EXISTS `t_member_switch`;
CREATE TABLE `t_member_switch`
(
    `id`           bigint                                                       NOT NULL AUTO_INCREMENT,
    `create_time`  datetime                                                     NULL     DEFAULT NULL COMMENT '创建时间',
    `update_time`  datetime                                                     NULL     DEFAULT NULL COMMENT '更新时间',
    `is_deleted`   tinyint UNSIGNED                                             NOT NULL DEFAULT 0 COMMENT '删除状态：0->未删除；1->已删除',
    `tenant_id`    varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL     DEFAULT NULL COMMENT '租户id',
    `state`        tinyint UNSIGNED                                             NULL     DEFAULT 0 COMMENT '开关状态：0-关 1-开',
    `member_model` tinyint UNSIGNED                                             NULL     DEFAULT 0 COMMENT '会员模块名：0-总开关 1-储值开关',
    PRIMARY KEY (`id`)
)
    ENGINE = InnoDB
    DEFAULT CHARACTER SET = utf8
    COLLATE = utf8_general_ci
    COMMENT ='会员相关开关'
    AUTO_INCREMENT = 48
;

-- ----------------------------
-- Records of t_member_switch
-- ----------------------------
BEGIN;
INSERT INTO `t_member_switch`
VALUES ('9', '2020-07-18 15:00:01', '2020-08-23 20:57:37', '0', '100002', '1', '0'),
       ('10', '2020-07-18 15:00:12', '2020-08-23 20:57:56', '0', '100002', '1', '1'),
       ('15', '2020-08-03 23:02:45', '2020-08-03 23:02:45', '0', '100156', '1', '0'),
       ('16', '2020-08-04 13:42:05', '2020-08-04 13:42:05', '0', '100158', '1', '0'),
       ('17', '2020-08-04 13:42:05', '2020-08-04 13:42:05', '0', '100158', '1', '1'),
       ('18', '2020-08-07 21:38:47', '2020-08-07 21:38:47', '0', '100159', '1', '0'),
       ('19', '2020-08-07 21:38:47', '2020-08-07 21:38:47', '0', '100159', '1', '1'),
       ('20', '2020-08-08 11:16:37', '2020-08-08 11:16:37', '0', '100160', '1', '0'),
       ('21', '2020-08-08 11:16:38', '2020-08-08 11:16:38', '0', '100160', '1', '1'),
       ('22', '2020-08-11 21:37:08', '2020-08-11 21:37:08', '0', '100161', '1', '0'),
       ('23', '2020-08-11 21:37:08', '2020-08-11 21:37:08', '0', '100161', '1', '1'),
       ('24', '2020-08-16 10:05:26', '2020-08-16 10:05:26', '0', '100162', '1', '0'),
       ('25', '2020-08-16 10:05:26', '2020-08-16 10:05:26', '0', '100162', '1', '1'),
       ('26', '2020-08-16 10:05:56', '2020-08-16 10:05:56', '0', '100162', '1', '0'),
       ('27', '2020-08-16 10:05:56', '2020-08-16 10:05:56', '0', '100162', '1', '1'),
       ('28', '2020-08-16 10:43:42', '2020-08-16 10:43:42', '0', '100162', '1', '0'),
       ('29', '2020-08-16 10:43:42', '2020-08-16 10:43:42', '0', '100162', '1', '1'),
       ('30', '2020-08-16 10:44:29', '2020-08-16 10:44:29', '0', '100162', '1', '0'),
       ('31', '2020-08-16 10:44:29', '2020-08-16 10:44:29', '0', '100162', '1', '1'),
       ('32', '2020-08-16 10:44:42', '2020-08-16 10:44:42', '0', '100162', '1', '0'),
       ('33', '2020-08-16 10:44:42', '2020-08-16 10:44:42', '0', '100162', '1', '1'),
       ('34', '2020-08-16 10:51:13', '2020-08-16 10:51:13', '0', '100162', '1', '0'),
       ('35', '2020-08-16 10:51:13', '2020-08-16 10:51:13', '0', '100162', '1', '1'),
       ('36', '2020-08-16 20:07:02', '2020-08-16 20:07:02', '0', '100163', '1', '0'),
       ('37', '2020-08-16 20:07:02', '2020-08-16 20:07:02', '0', '100163', '1', '1'),
       ('38', '2020-09-01 20:46:29', '2020-09-01 20:46:29', '0', '100164', '1', '0'),
       ('39', '2020-09-01 20:46:29', '2020-09-01 20:46:29', '0', '100164', '1', '1'),
       ('40', '2020-09-02 13:17:09', '2020-09-02 13:17:09', '0', '100165', '1', '0'),
       ('41', '2020-09-02 13:17:09', '2020-09-02 13:17:09', '0', '100165', '1', '1'),
       ('42', '2020-09-02 13:19:07', '2020-09-02 13:19:07', '0', '100166', '1', '0'),
       ('43', '2020-09-02 13:19:07', '2020-09-02 13:19:07', '0', '100166', '1', '1'),
       ('44', '2020-09-03 09:13:51', '2020-09-03 09:13:51', '0', '100167', '1', '0'),
       ('45', '2020-09-03 09:13:51', '2020-09-03 09:13:51', '0', '100167', '1', '1'),
       ('46', '2020-09-04 20:45:02', '2020-09-04 20:45:02', '0', '100168', '1', '0'),
       ('47', '2020-09-04 20:45:02', '2020-09-04 20:45:02', '0', '100168', '1', '1');
COMMIT;

-- ----------------------------
-- Auto increment value for t_member_balance_record
-- ----------------------------
ALTER TABLE `t_member_balance_record`
    AUTO_INCREMENT = 252;

-- ----------------------------
-- Auto increment value for t_member_card_goods
-- ----------------------------
ALTER TABLE `t_member_card_goods`
    AUTO_INCREMENT = 275;

-- ----------------------------
-- Auto increment value for t_member_card_info
-- ----------------------------
ALTER TABLE `t_member_card_info`
    AUTO_INCREMENT = 1589;

-- ----------------------------
-- Auto increment value for t_member_card_privilege
-- ----------------------------
ALTER TABLE `t_member_card_privilege`
    AUTO_INCREMENT = 181;

-- ----------------------------
-- Auto increment value for t_member_card_privilege_goods
-- ----------------------------
ALTER TABLE `t_member_card_privilege_goods`
    AUTO_INCREMENT = 1;

-- ----------------------------
-- Auto increment value for t_member_card_privilege_group
-- ----------------------------
ALTER TABLE `t_member_card_privilege_group`
    AUTO_INCREMENT = 1829;

-- ----------------------------
-- Auto increment value for t_member_card_privilege_rule
-- ----------------------------
ALTER TABLE `t_member_card_privilege_rule`
    AUTO_INCREMENT = 1;

-- ----------------------------
-- Auto increment value for t_member_info
-- ----------------------------
ALTER TABLE `t_member_info`
    AUTO_INCREMENT = 217;

-- ----------------------------
-- Auto increment value for t_member_order_info
-- ----------------------------
ALTER TABLE `t_member_order_info`
    AUTO_INCREMENT = 2204928;

-- ----------------------------
-- Auto increment value for t_member_pay_rule
-- ----------------------------
ALTER TABLE `t_member_pay_rule`
    AUTO_INCREMENT = 148;

-- ----------------------------
-- Auto increment value for t_member_rebate_settings
-- ----------------------------
ALTER TABLE `t_member_rebate_settings`
    AUTO_INCREMENT = 1;

-- ----------------------------
-- Auto increment value for t_member_register_form
-- ----------------------------
ALTER TABLE `t_member_register_form`
    AUTO_INCREMENT = 40;

-- ----------------------------
-- Auto increment value for t_member_switch
-- ----------------------------
ALTER TABLE `t_member_switch`
    AUTO_INCREMENT = 48;
